Re: [log4plsql] log4plsql

[log4plsql g. m. l. <log...@li...>]

Guillaume



On Wed, Jan 7, 2009 at 1:48 PM, <
Ber...@bo...> wrote:

>  Hi Guillaume,
>
> I think Tom should create public synonyms for the package PLOGPARAM and
> PLOG
>
> connected as sys:
>
> CREATE PUBLIC SYNONYM PLOGPARAM FOR PL.PLOGPARAM;
> CREATE PUBLIC SYNONYM PLOG FOR PL.PLOG;
>
> After that your users can use theses packages in their programs.
>
> If you have installed the PLOG_OUT_AQ package and use it as output
> (output in a queue) , you should replace the line
> l_queue_name := 'LOG_QUEUE';
> with :
> l_queue_name := 'PL.LOG_QUEUE';
>
> (if not the users will get an exception as they do not own this
> LOG_QUEUE)
>
> Regards
>
> Bertrand
>
>
>
>  -----Ursprüngliche Nachricht-----
> *Von:* Guillaume Moulard [mailto:gmo...@gm...]
> *Gesendet:* Mittwoch, 7. Januar 2009 11:08
> *An:* Bertrand Caradec
> *Betreff:* Fwd: log4plsql
>
> Bertrand,
>
>  Have you some information?
>
> Guillaume
>
>
>
> ---------- Forwarded message ----------
> From: DBA <db...@em...>
> Date: Tue, Jan 6, 2009 at 10:24 AM
> Subject: Re: log4plsql
> To: Guillaume Moulard <gmo...@gm...>
> Cc: log...@li...,
> bca...@se...
>
>
> Hi,
>
> log4plsql is installed under user pl.
> When i connect as user pl i am able to log all. I see in alert.log needed
> information.
> alert.log:
> --------
> Tue Jan 06 10:11:51 2009
> PLOG:2009-01-06 10:11:51:60 user: PL level: DEBUG logid: 57 firstSection
> Hello LOG
>
> but on the server are other users ( developers ) example martin01. When i
> connect under this user and run the same test:
> sqlplus:
> -------
> Declare
> pCTX PLOGPARAM.LOG_CTX := PLOG.init (pSECTION => 'firstSection',
> pLEVEL => PLOG.LDEBUG,
> pLOG4J => TRUE,
> pLOGTABLE => TRUE,
> pOUT_TRANS => TRUE,
> pALERT => TRUE,
> pTRACE => TRUE,
> pDBMS_OUTPUT => TRUE );
> begin
> PLOG.debug (pCTX, 'Hello LOG');
> end;
> /
>
> I get an error:
> --------------
> pCTX PLOGPARAM.LOG_CTX := PLOG.init (pSECTION => 'firstSection',
>    *
> ERROR at line 2:
> ORA-06550: line 2, column 6:
> PLS-00201: identifier 'PLOGPARAM.LOG_CTX' must be declared
> ORA-06550: line 2, column 6:
> PL/SQL: Item ignored
> ORA-06550: line 11, column 13:
> PLS-00320: the declaration of the type of this expression is incomplete or
> malformed
> ORA-06550: line 11, column 1:
> PL/SQL: Statement ignored
>
> QUESTION
> -------------
> Which packages must be granted to all developers ( or to public user ) when
> I need log all from different schema than pl.
>
>
> Regards,
> Tom
>
>
>
>
> Guillaume Moulard wrote:
>
>> Hi,
>>  Have you some information?
>>
>> Guillaume
>> On Tue, Jan 6, 2009 at 8:36 AM, DBA <> wrote:
>>
>>    Hi Guillaume,
>>
>>    may I have a question regarding log4plsql?
>>    I installed beta version 4 because we are on 11g. I did it per
>>    manual but now I want to use it under different user than "pl"
>>    Which packages I must grant to user or is there any sql script?
>>
>>    The reason is that log4plsql is installed under user pl but we
>>    have 3 developers which needs to log their own procedures under
>>    their own schema.
>>
>>    Thank you.
>>
>>    Regards,
>>    Tom
>>
>>    Guillaume Moulard wrote:
>>
>>
>>
>>         LinkedIn
>>
>>        *Guillaume Moulard* has sent you a message.
>>
>>        *Date:* 12/17/2008
>>
>>        *Subject:* RE: log4plsql
>>
>>        hello,
>>
>>        Could you send me you log () please.
>>
>>        G
>>
>>        On 12/16/08 5:57 AM, Tomas Solar wrote:
>>        --------------------
>>        Hi Guillaume,
>>
>>        i would like to try your tool log4plsq but during the install
>>        i am getting an error.
>>        Could i sent you install log to check it?
>>        I am not developer so i am not able to found an error.
>>
>>        tx & regards,
>>        Tom
>>        mail
>>
>>
>>
>>
>>
>
>