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 log
-- 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�rieur attribuer dynamiquement
) IS
nbrl number;
BEGIN
PLOG.ERROR('level:'||pLEVEL);
checkAndInitCTX(pCTX);
PLOG.ERROR('level:'||pLEVEL);
IF pLEVEL = NOLEVEL then
pCTX.LLEVEL := pCTX.INIT_LLEVEL;
END IF;
PLOG.ERROR('level:'||pLEVEL);


select count(*) into nbrl FROM TLOGLEVEL where TLOGLEVEL.LLEVEL=pLEVEL;
IF nbrl > 0 then
pCTX.LLEVEL := 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_id56&alloc_id438&op=click
_______________________________________________
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