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

From: RCB <Robert.Bodnar_at_alliedsignal.com>
Date: 1997/09/17
Message-ID: <341FF9CE.28D7@alliedsignal.com>#1/1

Input objects are associated with pl/sql variables based on their name. Multiple objects with the same name are passed as an array. Here's a short example of each. Once the variables are in the procedure, you can do any sort of manipulation on them you want.

CREATE OR REPLACE PROCEDURE input_form
IS
BEGIN

 htp.formOpen('output_form','post');
 htp.formText('input_value');
 htp.formSubmit;
 htp.formClose;

END;
/

CREATE OR REPLACE procedure output_form(input_value VARCHAR2) IS
BEGIN
 htp.print('input_value = '||input_value); END;
/

CREATE OR REPLACE PROCEDURE input_form2
IS
BEGIN

 htp.formOpen('output_form2','post');
 htp.formText('input_value');
 htp.formText('input_value');
 htp.formSubmit;
 htp.formClose;

END;
/

CREATE OR REPLACE PROCEDURE output_form2(input_value OWA_UTIL.IDENT_ARR) IS
 i INTEGER;
BEGIN
 i:=1;
 WHILE input_value.exists(i) LOOP
  htp.print('input_value(' || i || ') = '||input_value(i));   htp.br;
  i:=i+1;
 END LOOP;
END;
/
Received on Wed Sep 17 1997 - 00:00:00 CDT