Guillaume
On Wed, Jan 7, 2009 at 1:48 PM, < [email protected]> 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:[email protected]] > *Gesendet:* Mittwoch, 7. Januar 2009 11:08 > *An:* Bertrand Caradec > *Betreff:* Fwd: log4plsql > > Bertrand, > > Have you some information? > > Guillaume > > > > ---------- Forwarded message ---------- > From: DBA <[email protected]> > Date: Tue, Jan 6, 2009 at 10:24 AM > Subject: Re: log4plsql > To: Guillaume Moulard <[email protected]> > Cc: [email protected], > [email protected] > > > 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 >> >> >> >> >> > > ------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB _______________________________________________ Log4plsql-all-info mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net
