Toad Data Point 4.3 has a bug in Automation that did not exist in 4.2. Toad Data Point 4.3 has a bug when passing dates that are read via SQL. In the Initialize Variables Activity in Automation, if you create a variable type of SQL and use a SQL statement to select a date from SQL Server, instead of returning a date time variable, you get the SQL string '''To_date('06/01/2017 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')''' which is not recognized as a date. In TDP 4.2, a SQL variable type that selected a date field would return a date.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center