[log4plsql] PLOG.ERROR of setLevel should be comment out?
Brought to you by:
gmoulard
From: <log...@li...> - 2004-02-18 14:20:10
|
This is the procedure setLevel. When executed prints 3 error on the log=20 table. This behaveour is correct? PROCEDURE setLevel -- il est possible de modifier avec setLevell dynamiquement le niveau de= log -- l'appel de setLevel sans paramettre re-poossitionne le niveaux a celuis= =20 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=20 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=3DpLEVE= L; IF nbrl > 0 then pCTX.LLEVEL :=3D pLEVEL; ELSE raise_application_error(-20501, 'SetLevel ('||pLEVEL||') not in=20 TLOGLEVEL table'); END IF; EXCEPTION WHEN OTHERS THEN PLOG.ERROR; end setLevel; Regards, Francesco |