RE : [log4plsql] PLOG.ERROR of setLevel should be comment out?

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

Hi,

True I correct this small problem in next release.

Regards,
Guillaume Moulard
gmo...@us...

Project : LOG4PLSQL : Oracle Database Loggin tools
see : http://log4plsql.sourceforge.net/
and :  http://sourceforge.net/mailarchive/forum.php?forum=3Dlog4plsql-all-i=
nfo or
http://www.mail-archive.com/log...@li...
for  log...@li...

-----Message d'origine-----

De : log...@li... [mailto:log4plsql-all-i=
nfo...@li...]

Envoy=E9 : mercredi 18 f=E9vrier 2004 15:15

=C0 : log...@li...

Objet : [log4plsql] PLOG.ERROR of setLevel should be comment out?



This is the procedure setLevel. When executed prints 3 error on the log

table. This behaveour is correct?

PROCEDURE setLevel

-- il est possible de modifier avec setLevell dynamiquement le niveau de lo=
g

-- l'appel de setLevel sans paramettre re-poossitionne le niveaux a celuis

specifier

-- dans le package.

-- erreur possible : -20501, 'Set Level not in LOG predefine constantes' (

pCTX IN OUT NOCOPY LOG_CTX , -- Context

pLEVEL IN TLOG.LLEVEL%type default NOLEVEL -- Level

sup=E9rieur attribuer dynamiquement

) IS

nbrl number;

BEGIN

PLOG.ERROR('level:'||pLEVEL);

checkAndInitCTX(pCTX);

PLOG.ERROR('level:'||pLEVEL);

IF pLEVEL =3D NOLEVEL then

pCTX.LLEVEL :=3D pCTX.INIT_LLEVEL;

END IF;

PLOG.ERROR('level:'||pLEVEL);

select count(*) into nbrl FROM TLOGLEVEL where TLOGLEVEL.LLEVEL=3DpLEVEL;

IF nbrl > 0 then

pCTX.LLEVEL :=3D pLEVEL;

ELSE

raise_application_error(-20501, 'SetLevel ('||pLEVEL||') not in

TLOGLEVEL table');

END IF;

EXCEPTION

WHEN OTHERS THEN

PLOG.ERROR;

end setLevel;

Regards,

Francesco





-------------------------------------------------------

SF.Net is sponsored by: Speed Start Your Linux Apps Now.

Build and deploy apps & Web services for Linux with

a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=135=
6&alloc_id438&op=3Dick

_______________________________________________

Log4plsql-all-info mailing list Log...@li...

https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info

log4plsq : http://log4plsql.sourceforge.net