Toad World® Forums

Bind Variable error during Automation

I am having issues getting the error

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.