next up previous
Next: Printing HTML Tables Up: No Title Previous: Simple Example

Passing Parameters

GET method:

CREATE OR REPLACE PROCEDURE pl1(str in varchar2, 
                                num in number) AS
BEGIN
   htp.htmlOpen;
   htp.headOpen;
   htp.title('Parameters');
   htp.headClose;
   htp.bodyOpen;
   htp.line;
   htp.header(1,'Parameter Passing');
   htp.line;
   for i in 1..num loop
     htp.print(i || '. ' || str);
     htp.br;
   end loop;
   htp.line;
   owa_util.signature('pl1');
   htp.bodyClose;
   htp.htmlClose;
END;

http://tinman.cs.gsu.edu:9001/
   matxxxx/plsql/pl1?str=Hello&num=4

POST method: typically used with HTML forms; parameters are passed to standard input (PL/SQL cartridge automatically takes care of passing parameters as long as form element name is same as parameter name).



Dr. Raj Sunderraman
6/23/1998