isql-webforms

[patilanjana]

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.

<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>
 

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.

[debasisdas]

What that code is for ?

Is that Oracle code ?

[patilanjana]

The code is web form.

Anjana

[debasisdas]

The code is web form.

Anjana

Then why that is posted in oracle forum ?

Please post in related forum only.

[amitpatel66]

Thread moved to HTML forum

[drhowarddrfine]

Well, SQL web forms don't belong in the HTML forum either but I don't know where to send it.