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
>
|
