Quantcast
OracleBrains.Com header image 2

SQL*PLUS DBMS_OUTPUT Now and Then

November 25th, 2007 by Rajender Singh · No Comments

As per my experience when working with PL/SQL code, DBMS_OUTPUT is one of the most frequently used package to display debugging information.

But frequently when using 10G R1 and earlier versions, we come across something like as follows:

ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
Single line limit of 255 bytes exceeded.

ORA-20000: ORU-10027: buffer overflow, limit of bytes
Maximum amount of 1 million bytes per session exceeded.

10G R2 increases the single length line limit to 32,767 bytes and the overall session limit is removed altogether.

Note: Now myself and my team use our own procedure called LOGIT for debugging, I will explain it later.


Tags: Oracle Administration · Oracle Database · SQL*Plus

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Comment moderation is enabled. Your comment may take some time to appear.