By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,396 Members | 1,869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,396 IT Pros & Developers. It's quick & easy.


P: 7
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
Share this Question
Share on Google+
5 Replies

Expert 5K+
P: 8,127
What that code is for ?

Is that Oracle code ?
Feb 15 '08 #2

P: 7
The code is web form.

Feb 15 '08 #3

Expert 5K+
P: 8,127
The code is web form.

Then why that is posted in oracle forum ?

Please post in related forum only.
Feb 15 '08 #4

Expert 100+
P: 2,367
Thread moved to HTML forum
Feb 15 '08 #5

Expert 5K+
P: 7,435
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.