dbTalk Databases Forums  

replacement for DBMS_OUTPUT package?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss replacement for DBMS_OUTPUT package? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mh@pixar.com
 
Posts: n/a

Default replacement for DBMS_OUTPUT package? - 03-11-2009 , 01:14 AM






especially one that doesn't have the 256 max chars/line
and 1000000 max chars/buffer limitation.

any hints and pointers appreciated!!

TIA,
Mark

--
Mark Harrison
Pixar Animation Studios

Reply With Quote
  #2  
Old   
Maxim
 
Posts: n/a

Default Re: replacement for DBMS_OUTPUT package? - 03-11-2009 , 02:13 AM






On 11 Mrz., 08:14, m... (AT) pixar (DOT) com wrote:
Quote:
especially one that doesn't have the 256 max chars/line
and 1000000 max chars/buffer limitation.

any hints and pointers appreciated!!

TIA,
Mark

--
Mark Harrison
Pixar Animation Studios
Here are some implementation examples

http://www.amazon.com/Signature-Prog...6759036&sr=1-3
http://asktom.oracle.com/pls/asktom/...D:146412348066

Best regards

Maxim


Reply With Quote
  #3  
Old   
Magnus Bengtsson
 
Posts: n/a

Default Re: replacement for DBMS_OUTPUT package? - 03-11-2009 , 02:22 AM



mh (AT) pixar (DOT) com skrev:
Quote:
especially one that doesn't have the 256 max chars/line
and 1000000 max chars/buffer limitation.

any hints and pointers appreciated!!

If you are using older Oracle versions this won't help you, but:

In Oracle 10gR2 and 11gR1 the limit for the line size is 32767 bytes,
and the buffer size is unlimited.

/Magnus


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.