Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: spooling DBMS_OUTPUT from Pro*C

Re: spooling DBMS_OUTPUT from Pro*C

From: eric j. givler <egivler_at_flash.net>
Date: Sat, 16 Oct 1999 00:03:55 GMT
Message-ID: <3807c6f0.3914816@news.flash.net>


On Tue, 12 Oct 1999 14:57:52 -0500, paul cluiss <paul_cluiss_at_intervoice.com> wrote:

yeah... issue: dbms_output.enable( <put a # here> ); at the start inside a pl/sql block, then read it via dbms_output.get_lines in another pl/sql block. You can read until you get a status code of no more data. If you need source, email me at givler.eric_at_dep.state.pa.us
>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 Fri Oct 15 1999 - 19:03:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US