Re: PL/SQL & OraWeb 3.0: overloaded proc has performance hit

Why not write a Perl script to get what you want, and then pass what you want to a PL/SQL procedure? (You would use the Perl cartridge for this, of course.)

Steve Livingston wrote:

> Using: Oracle 7.3.2.2 & Oracle Webserver 3.0
>
> I've got a main procedure that has 20 overloaded copies.
>
> This runs OK (fast) from sqlplus.
>
> But...when executed from the web...response time goes to 4 seconds!?
>
> Has anyone seen this?
> Oracle help has not heard of this problem.
>
> By the way...I've used overloading because I web/POST info to PL/SQL,
> but PL/SQL does not (?) have access to the post-string. So I've
> overloaded my main routine to handle all combinations of 'param=value'
>
> from my web forms.
>
> What I really want is access to the post-string so I can parse it
> myself
> (a la cgi). Is this possible?
>
> Cheers,
> Steve
Received on Tue Sep 16 1997 - 00:00:00 CDT