Re: [log4plsql] Re: Urgent clarification
Brought to you by:
gmoulard
From: <log...@li...> - 2005-08-29 15:35:32
|
Thanks Luc, thank you very much for your time and replying me. I have solved this problem by creating multiple background processes and= =20 each process has different PIPE name. For the same process, PIPE name must be same for Stored Proc context and= =20 log4plsql.properties file --Raja On 8/29/05, Luc Tanguay <luc...@be...> wrote:=20 >=20 > Raja, >=20 > it may be possible to use section names with different log4j loggers. > For example, if you define the section named "firstSection", the > log4j.properties could have a line like: >=20 > log4j.logger.log4plsql.PIPENAME.USERNAME.firstSection=3DDEBUG, myAppender >=20 > where > PIPENAME is the name of the Oracle pipe (default is LOG_PIPE) > USERNAME is the Oracle user using the LOG4PLSQL package >=20 > Each section (or subsection) could have its own logger. >=20 > I got this info by looking at the source code for ReaderLogDataBase.sqlj > but I've not experienced it myself. > Can somebody confirm this? >=20 > Luc >=20 >=20 >=20 > log...@li... a =E9crit : >=20 > > Please let me know if it is not possible using the current log4plsql > > context. > > > > Thanks > > Raja > > > > > > On 8/24/05, *Raja Ram* <raj...@gm... > > <mailto:raj...@gm...>> wrote: > > > > Hi, > > > > I am just exploring the way log4plsql is working and I want some > > clarification. > > > > I have some stored procs like SP1, SP2, SP3 etc. and I have > > implemented log4plsql there. The log is going into TLOG table and > > finally it is going into a file called "lo4plsql.log". > > > > Now I want separate files for all the Stored Procedure. SO How can > > I implement this??? > > > > I will be really thankful to you and appreciate your time if you > > can answer my question as soon as possible. > > > > Regards > > Raja > > > > > > >=20 > -- > Luc Tanguay, ing./P. Eng. > BELL CANADA > PERFORMANCE ET HAUTE DISPONIBILITE/HIGH AVAILABILITY & PERFORMANCE > 1050 BEAVER HALL, 2e ETAGE/2nd FLOOR > MONTREAL (QUEBEC) H2Z 1S4, CANADA > TEL: (514) 786-6440 > CEL: (514) 229-7585 >=20 >=20 >=20 > |