470,563 Members | 1,996 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,563 developers. It's quick & easy.


Does any one know, how to call a stored procedure that accepts 3 arguments from a webform.

ex: create or replace PROCEDURE insertproject(jnum 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.
Expand|Select|Wrap|Line Numbers
  1. <form action="http://hostname:port/isqlplus/dynamic?script=http://hostname:port/~user/insertproject.sql" method="get">
  2.                <p>
  3.                  <h3> Enter Project's J#: </h3>
  4.                     <input type="text" name="jnum" size="35" />
  5.                </p>
  6.                <p>
  7.                  <h3> Enter Project's Name: </h3>
  8.                     <input type="text" name="jname" size="35" />
  9.                </p>
  10.                <p>
  11.                  <h3> Enter Project's City: </h3>
  12.                     <input type="text" name="city" size="35" />
  13.                </p>
  14.                <p>
  15.                  <input type="submit" value="Submit Insert" />
  16.                </p>
  17.           </form>
Thank you.

If I have violated any rules, it's not intentional. Help will be appreciated than a 2nd warning with second posting ever.
Feb 15 '08 #1
5 1203
8,127 Expert 4TB
What that code is for ?

Is that Oracle code ?
Feb 15 '08 #2
The code is web form.

Feb 15 '08 #3
8,127 Expert 4TB
The code is web form.

Then why that is posted in oracle forum ?

Please post in related forum only.
Feb 15 '08 #4
2,367 Expert 2GB
Thread moved to HTML forum
Feb 15 '08 #5
7,435 Expert 4TB
Well, SQL web forms don't belong in the HTML forum either but I don't know where to send it.
Feb 15 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Rui Cunha | last post: by
1 post views Thread by Jacob Grydholt Jensen | last post: by
6 posts views Thread by Alex Vilner | last post: by
1 post views Thread by Gary | last post: by
3 posts views Thread by anuu | last post: by
4 posts views Thread by Marcin Zmyslowski | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.