Re: Pro*C and 'set serveroutput on' for dbms_output.put_line

You need to make an Anonymous PL/SQL block and execte it like:

BEGIN   DBMS_OUTPUT.ENABLE(2000);   MYPROCEDURE( :p_param1, p_param2 );

  DBMS_OUTPUT.GET_LINES( :lines, :numlines );

END; and bind to the :lines and :numlines.

You can look at the package specification for the DBMS_OUTPUT package for more information. I have code that does this in OCI, but not Pro*C.

This SQL statement will give you the package header:

select text from all_source where type = 'PACKAGE' and name = 'DBMS_OUTPUT';

Take Care,

Robert Clevenger

Ron McCamish wrote in message <34EAFB56.911E032D_at_cas.org>...
>Does anyone know how to do a 'set serveroutput on' in Pro*C
>so that put_line's from stored procedures called from Pro*C
>will be printed?
>
>thanks,
>
>ron....
>--
>Ron McCamish
>rmccamish_at_cas.org
Received on Wed Feb 18 1998 - 00:00:00 CST