Re: spooling DBMS_OUTPUT from Pro*C

Your only chance is to redirect the stdout of your Pro*C program, and making a call to dbms_output.enable(<size of buffer in bytes>) before the first put_line.
If that doesn't work, you will need to replace all dbms_output by utlfile calls.

Hth,

--
Sybrand Bakker, Oracle DBA
paul cluiss <paul_cluiss_at_intervoice.com> wrote in message news:8BEBE870D403F406.2A793EA8D2FFC25C.6E3217E2B12C5458_at_lp.airnews.net...
> Hello everyone,
>
> I have a Pro*C program which makes calls to stored procedures in an
> Oracle package. This package has lots of debugging output in it of the
> form DBMS_OUTPUT() calls. The debugging output shows up on the SqlPlus
> session if serveroutput is ON, but I would like to also see this output
> spool'd whenever any of the package's procedures are called, namely from
> my Pro*C program, which isn't connected to any SqlPlus session. Does
> anyone know how to set this up?
>
> Thanks,
>
> Paul Cluiss
> Dallas, Texas
>
Received on Sun Oct 24 1999 - 11:16:11 CDT