Re: Need help with DBMS_OUTPUT in PL/SQL script

Kelley Brigman
> could use one of the predefined
> packages to set that command before you DBMS_OUTPUT.
> Try DBMS_SESSION or DBMS_UTILITY?

Well, you'll have more luck with using the package itself :-)

    dbms_output.enable(1000000);

> You could also use the UTL_FILE package to simply write your
> errors to a file instead of to the screen. Then you don't need to resize a
> buffer or worry about running out of space.

Furthermore, if you flush the file every now and then you can even monitor the output while the procedure is still running. SQL*Plus typically only reads the buffer when your SQL has completed (it calls dbms_output.get_line or get_lines as long as data is present). And if the procedure runs within a trigger you might never see the output at all.

Arjan. Received on Wed Apr 21 1999 - 00:00:00 CEST