Toad World® Forums

Use Variable in Automation Designer -> Execute Script

Hi,
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: www.toadworld.com/…/20080

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

Are there any suggestions/workarounds?

ok