Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Compile PL/SQL procedure containing ampersands from SQLPLUS
I wonder is there any way to compile a PL/SQL procedure from SQLPLUS
that contains following code fragment:
home_page('param_a=1¶m_b=2');
HTML savvy persons know this is used to pass parameters from a HTTP client request. When compiling the procedure using SQLPLUS, it interprets param_b as a variable and prompts the user to enter a value for it interactively. Of course this is a misbehaviour in this context.
Any idea to circumvent this? So far, we use TOAD to compile the stuff. But we want to be able to compile using scripts, not relying on a GUI tool. Received on Wed Oct 20 1999 - 15:18:02 CDT