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.