RE: [Log4plsql] Issues with pipe of log4plsql

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

Bonjour,

Right, it's small bug with big impact.

in attachement, you see a patch.

I test it with :
-----
declare
     pctx plog.log_ctx :=3D PLOG.init('hell0', PLOG.LALL, TRUE);
     mess TLOG.LTEXTE%type :=3D '';
begin
    for i in 0..1999 LOOP
        mess :=3D mess || 'A';
    end loop;

    plog.error(pctx, mess);
    commit;
end;
/
-----

Are is nice in yours environment ?


Cordialement / Regards,
Guillaume Moulard



> -----Message d'origine-----
> De : log...@li...
> [mailto:log...@li...]
> Envoy=E9 : mercredi 20 novembre 2002 18:12
> =C0 : 'log...@li...'
> Cc : Campoamor, Rich; Ivey, Joe
> Objet : [Log4plsql] Issues with pipe of log4plsql
>
>
> 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 :=3D 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