WebPage + PL/SQL procedure:

From: Zahid Khan <zahid_at_cc.gatech.edu>
Date: Wed, 04 Aug 1999 13:16:06 -0400
Message-ID: <37A87556.A285C72E@cc.gatech.edu>

I am running WebDb on Oracle 8i on an NT machine. I have made an html page which is a form and has three fields. How do I call the PL/SQL block in the <form> header tag?

This is how I am currently doing it and it isn't working: (the PL/SQL procedure is called testaccept)

<HTML>

:
snip snip
:

<FORM ACTION="SCOTT.testaccept" METHOD="POST"

________________^^^^^^^^^^^^^^^_______________

NAME="TEST_FORM" >
<INPUT TYPE="submit" NAME="p_request" VALUE="Insert">
<INPUT TYPE="reset" VALUE="Reset">

<br>
<! --- EmpNo input field --->
<INPUT TYPE="hidden" NAME="p_arg_names" VALUE="EMPNO">
<FONT COLOR="#70DB93" SIZE="+0">Empno</FONT>

<INPUT TYPE="text" NAME="p_empno" SIZE="22" MAXLENGTH="22" >
<! --- / EmpNo input field --->

<br>
<! --- Ename input field --->
<INPUT TYPE="hidden" NAME="p_arg_names" VALUE="ENAME">
<FONT COLOR="Black" SIZE="+0">Name</FONT>

<INPUT TYPE="text" NAME="p_ename" SIZE="10" MAXLENGTH="10" >
<! --- / Ename input field --->

<br>
<! --- Sal input field --->
<INPUT TYPE="hidden" NAME="p_arg_names" VALUE="SAL">
<FONT COLOR="Black" SIZE="+0">Salary</FONT>

<INPUT TYPE="text" NAME="p_sal" SIZE="22" MAXLENGTH="22" >
<! --- / Sal input field --->

</FORM>
Received on Wed Aug 04 1999 - 12:16:06 CDT