RE: [Log4plsql] Dynamical changes of log level

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

Bonjour,

Curently, you have 2 way for update dynamically the level :

1 : In package specifiation
----------------------------
in file pslog.sql you con read a line 68:
-------------------------------------------------------------------
-- Constants (tools general parameter)
-------------------------------------------------------------------

DEFAULT_LEVEL     CONSTANT TLOG.LLEVEL%type     :=3D LINFO;   -- LERROR def=
ault level.


the DEFAULT_LEVEL parmeter is use by a logger for aduste a
log level merorisation.

for exemple :
in developpment phase :
DEFAULT_LEVEL     :=3D LDEBUG ;
All log is store. After in production phase :
DEFAULT_LEVEL     :=3D LERROR ;
The WARN, INFO, DEBUG log is not store in database.




2 / by Log4j
---------------------------
If you use the Log4JbackgroundProcess and log4j, your have a very
detail log level configuration (see :  http://log4plsql.sourceforge.net/doc=
s/UserGuide.html#_Toc18472568)

you have :
1.You have all Log4j features
2.You can customize the output destination, output format  and output level=
 by hierarchical log Section
3.The log table is purged for sending a log to other destination

and is possible to have in log4j.properties a specific level for each secti=
on :
---exemple---

# Log all database message
log4j.logger.log4plsql=3DDEBUG
#log4j.logger.log4plsql.ULOG.testLog4jFeatures.codePart1=3DINFO
-------------


the documentation is very poor about this topic.


Regards,
Guillaume Moulard


Project : LOG4PLSQL : Oracle Database Loggin tools
see     : http://log4plsql.sourceforge.net/


> -----Message d'origine-----
> De : log...@li...
> [mailto:log...@li...]
> Envoy=E9 : jeudi 16 janvier 2003 18:01
> =C0 : 'log...@li...'
> Objet : [Log4plsql] Dynamical changes of log level
>
>
> Hello log4plsql team !
>
> I have a questions concerning log4plsql
>
> 1. dynamical changes of log level.
> My understanding is, that if I use log4plsql within a plsql
> package for
> logging and debugging purposes, I would initialize my logging
> context for
> that package and afterwards would use that logging context for all
> logging/debug purposes in all of my procedures/function
> within that package.
>
> After that, I'm not able to change the logging level of my
> stored PL/SQL
> procedure dynamically, since the package is stored in the
> database and will
> use the same log level in each call.
>
> Does you plan to implement some kind of loglevel
> configuration, which is
> stored in a database table and can be read each time  a
> PL/SQL procedure of
> my packages is called ? Or does somebody else is offering
> this functionality
> for log4plsql ?
>
> Regards,
>
> Torsten Rothacker
>
>