wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes How to Create and run Oracle Stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to Create and run Oracle Stored procedure" Watch "How to Create and run Oracle Stored procedure" New topic
Author

How to Create and run Oracle Stored procedure

praneeth ram
Ranch Hand

Joined: Sep 21, 2009
Posts: 60
hi i am new to oracle plsql.
i tried and failed to create and run the procedure with my requirements. can any please reply me with answer.

I want to create a procedure as bellow.

stored procedure name: getsomenumber
This procedure takes two parameters dsid(input parameter), createuserid(out put parameter) both are varchar type only.
If i pass input parameter "sai" to the above stored procedure it should return 'sai2'.


can any one please give me the code and explain how to execute it.

Thanks,
Praneeth.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to Create and run Oracle Stored procedure
 
Similar Threads
Java code to access a stored procedure
Nested table of Nested tables in JDBC
Passing multiple values to a stored procedure
how to configure jobs in TOAD?
CLOBS