Thanks Luc, thank you very much for your time and replying me.
I have solved this problem by creating multiple background processes and each process has different PIPE name.
For the same process, PIPE name must be same for Stored Proc context and log4plsql.properties file
--Raja
On 8/29/05, Luc Tanguay <[EMAIL PROTECTED]> wrote:
Raja,
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:
log4j.logger.log4plsql.PIPENAME.USERNAME.firstSection=DEBUG, myAppender
where
PIPENAME is the name of the Oracle pipe (default is LOG_PIPE)
USERNAME is the Oracle user using the LOG4PLSQL package
Each section (or subsection) could have its own logger.
I got this info by looking at the source code for ReaderLogDataBase.sqlj
but I've not experienced it myself.
Can somebody confirm this?
Luc
[EMAIL PROTECTED] a écrit :
> Please let me know if it is not possible using the current log4plsql
> context.
>
> Thanks
> Raja
>
>
> On 8/24/05, *Raja Ram* <[EMAIL PROTECTED]
> <mailto: [EMAIL PROTECTED]>> 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
>
>
>
--
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
