Re: DBMS output limmits
From: Richard Hull <rich_at_work_at_bigfoot.com>
Date: Fri, 13 Nov 1998 08:48:47 -0500
Message-ID: <72hdmc$j6e$1_at_lore.csc.com>
Date: Fri, 13 Nov 1998 08:48:47 -0500
Message-ID: <72hdmc$j6e$1_at_lore.csc.com>
[Quoted] Hi Chris,
My understanding is that the 1M dbms_output limit is server imposed. The padding of lines on output is an SQL*Plus behaviour which I do not think contributes to the 1M limit. BTW, this SQL*Plus behaviour can be changed with the SET TRIMOUT ON (and SET TRIMSPOOL ON). If you use these commands, you will notice that your output is produced significantly faster.
-Rich. Received on Fri Nov 13 1998 - 14:48:47 CET