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

From: Kevin Johnson <kevin_at_johnson-and-johnson.freeserve.co.uk>
Date: Sat, 31 Oct 1998 14:22:18 -0000
Message-ID: <71f6ck$6bp$1@newsreader2.core.theplanet.net>

DJ,

When dealing with limitations in DBMS_OUTPUT, I have had some success in the past by creating my own DBMS_OUTPUT package which wrote to a database pipe instead of returning the output back to the original session. Then another session could read from the pipe to see the results.

I don't know if this will work for you but you might like to post your findings if you try it.

Regards, Kevin.

dc-johnson_at_home.com wrote in message ...
>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
Received on Sat Oct 31 1998 - 08:22:18 CST