Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output needed in a pl/sql wrapped by Pro*C

Re: dbms_output needed in a pl/sql wrapped by Pro*C

From: Jurij Modic <jmodic_at_src.si>
Date: Sat, 31 Oct 1998 23:22:32 GMT
Message-ID: <363b6cf5.14168265@news.siol.net>


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)



The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Oct 31 1998 - 17:22:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US