[Log4plsql] Issues with pipe of log4plsql

[<log...@li...>]

Hi, 

I am trying to use log4plsql logging off transaction limit option using the
Log4JBackgroundProcess or background process. However, I am quickly running
into problem on how big a message I can send:


Here is an example:

I session one: 
declare
     pctx plog.log_ctx := PLOG.init('hell0', PLOG.LALL, TRUE);
begin
    plog.error(pctx, 'hello hello hello hello hello hello hello hello');
    commit;
end;
/

In another session:

exec plog.background_log;

ERROR at line 1:
ORA-20502: error see tlog in section : background_Log ORA-06502: PL/SQL:
numeric or value error: character string buffer too small
ORA-06512: at "LOGGER.PLOG", line 443
ORA-06512: at line 1

Basically, if I am not mistaken, it seems that the buffer for the pipe gets
filled up. My question: is there anything I can do to overcome this buffer
too small problem? I need to log some messages bigger than 30 characters. 

Thanks, 


Lu Cheng
Database Administration Consultant
Fidelity Wide Processing
100 Crosby Parkway, KP2B
Covington, KY 41015
*Phone: 859-386-5173
*Fax:     859-291-1913