Home » SQL & PL/SQL » SQL & PL/SQL » Server Output size UNLIMITED (Oracle 11G)
Server Output size UNLIMITED [message #550810] Thu, 12 April 2012 10:19 Go to next message
sinpeak
Messages: 34
Registered: January 2011
Location: india
Member
Hi,

Is :

DBMS_OUTPUT.ENABLE(NULL);


equivalent to :

SET SERVEROUTPUT ON SIZE UNLIMITED;


?


Thanks.
Re: Server Output size UNLIMITED [message #550813 is a reply to message #550810] Thu, 12 April 2012 10:26 Go to previous messageGo to next message
John Watson
Messages: 4093
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 Go to previous message
Michel Cadot
Messages: 57617
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: SQL clause retreiving information from a varray
Next Topic: Query for unnest a table
Goto Forum:
  


Current Time: Mon Apr 21 11:31:48 CDT 2014

Total time taken to generate the page: 0.13029 seconds