# Bind Variable error during Automation

**URL:** <https://forums.toadworld.com/t/bind-variable-error-during-automation/31315>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [October 22, 2014, 9:38am UTC](https://forums.toadworld.com/t/bind-variable-error-during-automation/31315 "2014-10-22T09:38:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![CMAC85](https://avatars.discourse-cdn.com/v4/letter/c/9dc877/32.png) [@CMAC85](https://forums.toadworld.com/u/CMAC85)\
**Post date:** [October 22, 2014, 9:38am UTC](https://forums.toadworld.com/t/bind-variable-error-during-automation/31315/1 "2014-10-22T09:38:26Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [October 22, 2014, 6:39pm UTC](https://forums.toadworld.com/t/bind-variable-error-during-automation/31315/2 "2014-10-22T18:39:14Z")

</div>

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.
