Toad World® Forums

SQL Navigator prompts for "Value of a Substitution Variable"


#1

vact varchar2(50);

vact := 'R & P;

end;

Team:

I use SQL navigator 5.0.0.607.

For the past one month whenever I run any SQL block with ampersand in it, it prompts me to “enter value for substitution variable”

Like when I try to create this

create or replace procedure test asbegindbms_output.put_line('vact ’ ||vact**);**
It prompts for a susbstitution value. However if I escape the & with &, the it is fine. This is the causing me issues. So for every string that contains &, I have to escape it with .

It does not happen in any of my collegaues SQL Navigator. I must have accidentally turned on or off something. Can you please let me know what setting shud I change so that this will not happen?


#2

You have to turn off the Scan defines/Subsitutions option OFF. Look for a button that has “:&” on the code editor toolbar. Hope this helps.

Gwen


#3

Thanks that fixed the problem.