[log4plsql] Fwd: PLOG_OUT_DBMS_OUTPUT
Brought to you by:
gmoulard
|
From: log4plsql g. m. l. <log...@li...> - 2010-06-29 14:17:36
|
From: John Finlay
Date: Thu, Jun 24, 2010 at 23:18
Subject: PLOG_OUT_DBMS_OUTPUT
To: guillaume
Guillaume,
I've attached an update (actually a replacement) for the
PLOG_OUT_DBMS_OUTPUT.LOG procedure.
The original version indented the message text to whatever length the header
(timestamp-severity-callstack) was, which made for some strange output like
14:58:12.73-FATAL-block:2->MORE.STUFF:27->EVENMORE.STUFF:128 Here is my
message that wraps at 100
characters
which looks kind of weird
and wastes a
lot of space. Big deal o
n the space,
but still...
Unfortunately, the original code used the pCTX.DBMS_OUTPUT_WRAP value as the
maximum length of the line (as it should), so if the
timestamp-severity-callstack is greater than 100 characters, there's no room
left for the message, and the procedure loops and throws an ORU-10027 buffer
overflow error.
This new version uses a constant indent (of 3 spaces), so wrapped output now
looks like
14:58:12.73-FATAL-block:2->MORE.STUFF:27->EVENMORE.STUFF:128 Here is my
message that wraps at 100
characters which looks much nicer and is easier to read because there is
actually some length to
the message line's output and at least it never explodes.
John Finlay
|