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

I think you can achieve the same effect as a pipe by using dbms_output.get_line at your client application (forms pl/sql. pl/sql block in pro*c) to retrieve the line of text put by the stored package.

Lawrence

Kevin Johnson wrote in message
<71f6ck$6bp$1_at_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 Sun Nov 01 1998 - 05:12:50 CST