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