Meaningless Drivel is fun!*
The moose likes Oracle/OAS and the fly likes passing parameters between procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "passing parameters between procedures" Watch "passing parameters between procedures" New topic
Author

passing parameters between procedures

Ravi Kumar
Greenhorn

Joined: Sep 07, 2005
Posts: 24
Hi,

I need help. i have a form in a procedure and getting the parameters in the form. Now This procedure is called from OAS portal page. The portal page is Pl/SQL page and it calls the procedure. When the page is called it displays the form. So when they submit the data. I should insert that data into the database and later display it. For that in my package I have 2 procedures. One that displays the form and other that gets the data and inserts into the database. What i did is in the action I am calling the procedure that accepts the paramters. But because I can't call a proceure directly I am getting an error page. What I want is when I hit the submit button the values should be forwarded to another page that calls the procedure to insert data into database.How do I do that. Can anyone help me with this how do it. Any help would be really appreciated.
Thanks.
 
Don't get me started about those stupid light bulbs.
 
subject: passing parameters between procedures