I am an absolute beginer to Oracle so this Q may seem VERY SIMPLE but please humor me ... i DESPERATELY need the answer....:
I have written a Stored Procedure which takes in an IN parameter and returns a single OUT value.
When I run this procedure from the SQL> prompt it runs and comes back with a message saying "PL/SQL Procedure Successfully Completed" but I cannot see the returned value on the screen!!!!
How do I see this?? To extend the issue ... if the procedure is going to retun an entire row or a set of rown how will I see them???
Also if I am going to call the procedure from PHP script how will i use the returned value(s)??
Please H E L P !!!!
Click Here to Expand Forum to Full Width