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 !!!!