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;