posted 12 years ago
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.