|
Re: Server Output size UNLIMITED [message #550813 is a reply to message #550810] |
Thu, 12 April 2012 10:26   |
John Watson
Messages: 8981 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
No:c:\users\john\home>sqlplus jon/jon
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 12 16:23:51 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Session altered.
orcl> exec dbms_output.put_line('something')
PL/SQL procedure successfully completed.
orcl> exec dbms_output.enable(null)
PL/SQL procedure successfully completed.
orcl> exec dbms_output.put_line('something')
PL/SQL procedure successfully completed.
orcl> set serveroutput on size unlimited
orcl> exec dbms_output.put_line('something')
something
something
PL/SQL procedure successfully completed.
orcl>
|
|
|
Re: Server Output size UNLIMITED [message #550817 is a reply to message #550810] |
Thu, 12 April 2012 10:32  |
 |
Michel Cadot
Messages: 68765 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
The first one allocates the buffer in your session memory.
The other one instructs SQL*Plus to 1) allocate the same buffer and 2) search for and display the content of this buffer each time Oracle (server) returns.
Regard
Michel
|
|
|