Does any one know, how to call a stored procedure that accepts 3 arguments from a webform.
ex: create or replace PROCEDURE insertproject(j num J.J#%type, jname J.JNAME%type, city J.CITY%type) IS .........
I think the following form action is the key. Any other advice is most welcome.
From a web form.
Thank you.
Anjana
If I have violated any rules, it's not intentional. Help will be appreciated than a 2nd warning with second posting ever.
ex: create or replace PROCEDURE insertproject(j num J.J#%type, jname J.JNAME%type, city J.CITY%type) IS .........
I think the following form action is the key. Any other advice is most welcome.
From a web form.
Code:
<form action="http://hostname:port/isqlplus/dynamic?script=http://hostname:port/~user/insertproject.sql" method="get">
<p>
<h3> Enter Project's J#: </h3>
<input type="text" name="jnum" size="35" />
</p>
<p>
<h3> Enter Project's Name: </h3>
<input type="text" name="jname" size="35" />
</p>
<p>
<h3> Enter Project's City: </h3>
<input type="text" name="city" size="35" />
</p>
<p>
<input type="submit" value="Submit Insert" />
</p>
</form>
Anjana
If I have violated any rules, it's not intentional. Help will be appreciated than a 2nd warning with second posting ever.
Comment