I have an automation script that executes a sql script that contains bind variables.
One of the bind variables has to contain a wildcard (%).
I keep getting an error message: ‘Invalid variable’ when the script executes.
This script creates a copy of a file that uses this variable, and that part is working (ie it creates a file for me with ‘Japan-B%’ as the file name (B% is the value passed to the bind variable).
However, this variable is also used in the WHERE clause of the sql and this is the part that seems to not be working.
When I turn on Verbose, I can see the messgage ‘Variable value = Invalid character’
Are wildcards not supported? Or am I doing something wrong?
Toad for Data Analysts: 188.8.131.521
Running against an Oracle database.