aspose file tools*
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 Spring in Action this week in the Spring 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