Toad World® Forums

TOAD seeing url parameter with & sign as bind variable


#1

Hello,

Does any one know how to make TOAD avoid seeing url parameters with the & sign as a bind variable. I have provided a sample I keep getting the variable substitution dialog box and have to type in all 20 substitutions for my url. I have tried single
quotes and double quotes.

Any help is greatly appreaciated

Thanks in advance.

Example

my url
http://www.test.com/test?code1=1&code2=2

In TOAD

DECLARE
test_url VARCHAR2(255);
BEGIN
test_url := 'http://www.test.com/test?’;

     test_url := test_url || '&code1=1';
     test_url := test_url || '&code2=2';

DBMS_OUTPUT.PUT_LINE(test_url);
END;


#2

If running as a script, add SET DEFINE OFF to the top of your script.

Also, check Options -> Execute/Compile -> Substitution Variable Prompting.