This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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 Introducing JavaFX 8 Programming this week in the JavaFX 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
 
It's not a secret anymore!