Toad World® Forums

Use Variable in Automation Designer -> Execute Script

I tried in every way to pass a variable to a simple sql script but it doesn’t work.

i have tried to use #, % and other but the only way that don’t see error is : after the name of variabile.

My script is:

Update table set field = :my_var where field is null;

Any suggestion?

You’re correct. I had a similar experience, I think TDP support only : and &.

It allows # in automation though. Couldn’t find any reason/details but any additional information will be appreciated.

Related link:…/20080

I use the variable not with Toad Data Point but with Toad For Oracle.

Are there any suggestions/workarounds?