Toad World® Forums

Substitution variables in Unified editor


#1

Hello,
I think I found a problem with the unified editor as substitution variables are not working properly.

I tested this simple query “select &aa from dual” and it ends with an ORA-01008 (not all variables bound).
It took me some time to see the Substitutions panel appear automatically on the right side of the window, but anyway, even specifying a value over there doesn’t work.

And yes, my button (:&) on the toolbar is enabled.

Hope it’s useful,
Paolo


#2

Also something that is missing is the possibility to replace the quoted substitution variables.
For example, if I put in my query the quoted variable ‘&p_asg_num’, it won’t be detected at all by SQLNav and no prompt will be made for substitution.
This will make a lot of scripts unusable, because SQL*Plus works fine with quoted substitution variables.

Thanks,
Paolo


#3

I’ve fixed the first issue. Note that substitution works in beta3 for scripts, the problem is with single SQL statements.

The second issue is a bit more difficult, but I promise to address it before GA release.

Roman


#4

Roman,
I am back with feedback for beta4.
The substitution variables do not work at all, neither in SQL scripts nor in single SQL queries.

The panel does not prompt for a value to substitute the variables and it’s not possible to change the value manually, it just defaults to the name of the variable.

That’s very bad, I hope you can fix it.

Thanks,
Paolo


#5

As mentioned in post:
http://sqlnavigator.inside.quest.com/thread.jspa?threadID=2483&tstart=0
The Substitution Variables functionality is to be brought more-in-line with the old editor(s).
Currently it is not intuitive, how to set them.
CR has been raised for this!

  • Jaime -