Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_OUTPUT
>Subject: DBMS_OUTPUT
>From: Yaoming Duan <duanyx_at_wssosg12>
>Date: 1/27/98 6:25PM GMT
>Message-id: <Pine.SOL.3.91.980127131947.3566A-100000_at_wssosg12>
>
>When I call stored procedure from sqlplus,
>I can use
> set serveroutput on
>to let dbms_output.put_line in my stored procedure to
>print debug message, but if I call a stored procedure from
>in a C program, how can I let dbms_output.put_line to
>print the debug message? "set serveroutput on" is a sqlplus
>command, can not be executed in a stored procedure.
>
>Thanks
>
>duanyx_at_itd.ssb.com
>
>
>
>
>
>
>
Use dbms_output.enable(n) where n is the size of the buffer you want Rob Received on Wed Jan 28 1998 - 00:00:00 CST