This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths 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 Head First Android this week in the Android 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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to Create and run Oracle Stored procedure
 
It's not a secret anymore!