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.

>

>Thanks for
>the thoughts and ideas, DJ
>
>
>
> -**** Posted from Supernews, Discussions Start Here(tm) ****-
>http://www.supernews.com/ - Host to the the World's Discussions & Usenet
You nee to use utl_file package. It also has the added advantage that you can use format strings (albeit rather crude format strings).

Regards,

Clive
--
Clive Bostock Received on Sun Nov 01 1998 - 12:11:30 CST