problem with '&' in install scripts on WinXP

[6502]

Hi!

I exported a plsql-package to file. This package uses the plsql-web-interface and therefore contains some hardcoded links with parameters to other stored procedures (htp.anchor).

Example:

--the code in the script file
--snip----------
htp.anchor(curl => 'mypackage.aprocedure'
||'?p_parameter_1='||v_param1
||'&p_parameter_2='||v_param2
,ctext => 'main level'
);
--/snip----------

After running the script, no matter if using TOAD or SQL*Plus, the code in the database looks like this:

--the code in the stored procedure
--snip----------
htp.anchor(curl => 'mypackage.aprocedure'
||'?p_parameter_1='||v_param1
||'='||v_param2
,ctext => 'main level'
);
--/snip----------

In TOAD, pre-run-scanning for substitution vars was switched off. In SQL*Plus, the "set define off" was given. Both did not ask for substitution, so it should work normally. It works on Unix/Linux of course, but I want to solve the problem on WinXP.

Best regards
6502

[lesstjm]

I had a problem like this before. I think you have to say set define off before you try to compile the code.

[6502]

I entered "set define off" before. If I did not, SQL*Plus would have asked me for the value of the mistaken variables. Furthermore, when using TOAD for running the script, the same problem occurs.

I could code around the problem by using chr(38) instead of '&', but I want to know the reason for this behaviour.

6502