Re: Compile PL/SQL procedure containing ampersands from SQLPLUS

From: Rudi Demeulenaere <rdm_at_datafront.nospam.be>
Date: Fri, 29 Oct 1999 17:51:55 +0200
Message-ID: <3819C29A.29678DAF@datafront.nospam.be>

bmlam wrote:

> I wonder is there any way to compile a PL/SQL procedure from SQLPLUS
> that contains following code fragment:
>
> home_page('param_a=1&param_b=2');

set define off

before launching the "create or replace" containing script.

It's your call, but this kind of using procedures for http seems a detour, knowing that cgi behaviour is supposed to convert your key/value-pairset already into usable environment parameters, so you could call any URL like "./home_page?param_a=1&param_b=2" if you just created "create or replace procedure home_page (param_a varchar2, param_b varchar2) begin; null; /*stuff */ end;"

</rudi> Received on Fri Oct 29 1999 - 10:51:55 CDT