WORKAROUND #!:
Use a convert function in your query, so you are sure you will use the correct datatype.
WORKAROUND #2:
Use literal replacements, instead of bind variables. When you use bind variables, you must supply the correct datatype as the binding is done in the database. When using a literal value, the automation code will edit the executing SQL with the literal values.
Example: Use the #var# syntax like below.
Where table.col = #FY# col = number
And table.col = #PER# col = number
And table.col = ‘#MONTH#’ col = string (must be surrounded in quotes for string literal)
When executing this SQL that uses automation, variables the SQL gets changed to:
Where table.col = 2019
And table.col = 9
And table.col = ‘March’
For Example...
Select * from table where my_varchar_column = TO_CHAR(:BIND_VAR)"
STATUS:
Waiting for a fix to be released in a future version of Toad Data Point.
