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

From: Steve Livingston <slivings_at_digitalriver.com>
Date: 1997/09/16
Message-ID: <341E8371.D5F5F298@digitalriver.com>#1/1

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