File_1 - Toad has detected some symbols within the expression indicating you might be using bind variables. Please define the following variable(s):
TITLE_REFERENCE
While trying to do a Select to FIle option in Automation. I also experience this error while doing a Saved Export in Automation though the export has no issues when running outside of Automation. I do not encounter this error in the previous version I was using.
Current Version: Version 3.6.0.3276
Previous Version:Version 3.4.0.2038
I’ve seen this issue in Toad World previously but nothing recently and hadn’t experienced this until trying to use the new version.
I discussed a similar issue with someone else today. I their case they had an Oracle connection and they were using the ‘&’ symbol. We were detecting this as a bind var but it wasn’t.
They had this in thier SQL.
WITH VAR_CO AS ( SELECT TRIM(‘FPC’) AS CO FROM DUAL ), VAR_BV AS ( SELECT TRIM(‘E’||’&’||'CS FCST …
This issue is due to the ‘&’. We are detecting it as a bind var without a name. This symbol is used by Oracle SQL *Plus. It evaluates to the variable with empty name. I believe if you use this instead you will avoid the issue.
select TRIM('E&CS FCST…
Do you have anything similar? If not please post your automation script and dependent files so we can have a look.