PL/SQL Procedure Output View
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PL/SQL Procedure Output View

  1. #1
    Join Date
    Nov 2000
    Posts
    2
    Hi,

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

    Rgds

  2. #2
    Join Date
    Oct 2000
    Posts
    123
    Do one thing: in the procedure, add DBMS_OUTPUT.PUT_LINE built-in function to output whatever you want just before the end or wherever you want to put in. And don't forget setting server output on by "set serveroutput on" in sqlplus.

    If the output is a set which has potential large number of characters, then add option "size 1000000" following the "set serveroutput on".

    Take care

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width