Hello! I am attempting to use a variable in a query in the Toad automation designer (v12.11).
In control, I use the Create Variable step and I put VAR_CP for variable and TEST for value. Scope is Local (current run).
The next step is a script step. Eventually, this will be an update such as:
Update MYTABLE set x=3 where MyValue=VAR_CP
I’ve tried a lot of different ways to do this:
etc - The error in all cases is Bind Variable not declared.
I just declared it - or thought I did.