File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Create and run Oracle Stored procedure

praneeth ram
Ranch Hand
Posts: 60
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic