Re: Running a PL/SQL block from a webpage:
Date: Wed, 04 Aug 1999 14:23:34 -0400
Message-ID: <37A88526.6CAB675A_at_mitre.org>
Take a look at the source (from your browser) that webdb uses to do
this,
should look something like:
<FORM ACTION="DW2.patrol_loc_edit.accept" METHOD="POST" NAME="patrol_loc_edit" onSubmit="return checkAll();">
If webdb is not serving up the page, you might have to put a more complete URL in, to force it to get handled by webdb.
-Peter
Zahid Khan wrote:
>
> 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 - 20:23:34 CEST