Re: Need help with DBMS_OUTPUT in PL/SQL script
From: Kelley Brigman <kelley.brigman_at_ac.com>
Date: 1999/04/21
Message-ID: <371E0A4C.708A62C9_at_ac.com>#1/1
Date: 1999/04/21
Message-ID: <371E0A4C.708A62C9_at_ac.com>#1/1
In SQL*Plus, you increase the size of the buffer with:
SQL>set serveroutput on buffer 20000
The default is 2000. You'll need to set this at the beginning of your
script. Or, if you're using a procedure, could use one of the predefined
packages to set that command before you DBMS_OUTPUT. Try DBMS_SESSION or
DBMS_UTILITY? 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.
Received on Wed Apr 21 1999 - 00:00:00 CEST