Hi!

I found following code in plog.log, LOG4PLSQL_VERSION  =  '3.1.3.0' (similar in 
older versions)):
...
hdr := TO_CHAR(pLDATE, 
'HH24:MI:SS')||':'||LTRIM(TO_CHAR(MOD(pLHSECS,100),'09'))||'-'||getLevelInText(pLLEVEL)||'-'||pLSECTION||'
 ';
...
sys.DBMS_OUTPUT.PUT(hdr);
...
If pLSECTION is very big (several calls through packages) then following error 
happens:
ORU-10028: line length overflow, limit of 255 chars per line.

First recommendation:
Filter out in plog.callurname duplicate items, eg. call stack in the same 
package, to shorten pLSECTION.
Second recommendation:
Substring the second line above before output it to a length lower than 255 and 
think about exactly the wrapping which follows in plog.log.
 

With kind regards / Mit freundlichen Gruessen
------------------------------------------------------------------------------------
Dipl.-Ing. Torsten Kleiber
Organisation und Informationsverarbeitung - Anwendungsentwicklung
IKB Deutsche Industriebank AG
Wilhelm-Bötzkes-Strasse 1
40474 Düsseldorf

Fon +49 (211) 82 21-41 21
Fax +49 (211) 82 21-21 21
mailto:[EMAIL PROTECTED]
http://www.ikb.de

Diese Email begründet keine Verpflichtung der IKB, es sei
denn dies wäre durch schriftliche Vereinbarung mit dem
Empfänger vereinbart.

This emails contents do not constitute a commitment by
IKB, except where provided for in a written agreement
between the bank and the recipient of this message.
------------------------------------------------------------------------------------
 


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Log4plsql-all-info mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
log4plsq : http://log4plsql.sourceforge.net

Reply via email to