Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output needed in a pl/sql wrapped by Pro*C
On Fri, 30 Oct 1998 13:53:05 -0800, dc-johnson_at_home.com () wrote:
>I need to debug a PL/SQL package. I am using the dbms_output.put_line
>capabilities, which will
>allow minimal messaging in SQLPlus. Is there
>anyway to turn on the output so that I can stretch it
>for use in a PL/SQL
>package that is being called by a Pro*C app?
>
>Any other ideas that would
>do the same thing? My real problem is that I can't figure a way to issue
>the SET SERVEROUTPUT ON xxxxxx command to the Pro*C cursor.
SET SERVEROUTPUT ON is strictly SQL*Plus's and svrmgr's command. If you want to retrive the contents of the output buffer from inside PL/SQL you must call DBMS_OUTPUT.GET_LINE or DBMS_OUTPUT.GET_LINES procedures.
>
>Thanks for
>the thoughts and ideas, DJ
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)