OAS Passing Parms

OAS Passing Parms


	Passing Parameters with the Application Server can be done using the URL:

	http://yourserver/dcdstuff/package.procedure?parm1=abc&parm2=123

	If generating this call in your PL/SQL, you will have to code as follows
 	because of the &, which won't compile in the stored procedure.

	htp.anchor('package.procedure?parm1='||parm1value||CHR(038)||'parm2='||parm2value,'Label');

	The CHR(038) generates the ampersand, which is the delimiter.



You can also call in a HTML form as follows: <FORM ACTION="package.procedure" METHOD="POST"> <INPUT TYPE="TEXT" NAME="parm1" VALUE="abc"> <INPUT TYPE="TEXT" NAME="parm2" VALUE="123"> </FORM> This can also be generated using the PL/SQL Language to generate the above.


Finally, you can test the stored procedure at the SQLPLUS prompt as follows: set serveroutput on; exec package.procedure('abc','123'); exec owa_util.showpage; The third line will return the HTML to SQLPLUS if your procedure is bug free.