Thread: [log4plsql] RE: log4plsql
Brought to you by:
gmoulard
Menu
▾
▴
log4plsql-all-info
|
From: <log...@li...> - 2004-01-22 13:10:52
|
Hi,=20 =20 In my dreams most fantastic, I think to log4db.=20 All database developpeurs can log in table with or without=20 specific database code and after all log is process and=20 send to log4J.=20 Perhaps is insteresting for log4plsql if a test and=20 setup the Chainsaw's JDBCReceiver with log4plsql? Regards,=20 Guillaume Moulard=20 gmo...@us... Project : LOG4PLSQL : Oracle Database Loggin tools see : http://log4plsql.sourceforge.net/ =20 =20 -----Message d'origine----- De : Scott Deboy [mailto:sd...@co...] Envoye : mardi 20 janvier 2004 23:11 A : gmo...@us... Objet : log4plsql Hi Guillaume, Not sure if you knew this, but I wanted to let you know there is a JDBCReceiver that can retrieve events from the TLOG table and display them in Chainsaw v2. If you're interested in trying it out or have questions, let me know. Chainsaw v2's page is here: http://logging.apache.org/log4j/docs/chainsaw.html and JDBCReceiver is here: http://cvs.apache.org/viewcvs.cgi/jakarta-log4j-sandbox/src/java/org/apa che/log4j/jdbc/JDBCReceiver.java?rev=3D1.13&view=3Dauto Take care, Scott |
|
From: <log...@li...> - 2004-05-17 15:30:06
|
Hi, For me there is only Oracle8 or more. Regards, Guillaume Moulard gmo...@us... Project : LOG4PLSQL : Oracle Database Loggin tools see : http://log4plsql.sourceforge.net/ and : http://sourceforge.net/mailarchive/forum.php?forum=3Dlog4plsql-all-i= nfo or http://www.mail-archive.com/log...@li... for log...@li... -----Message d'origine----- De : log...@li... [mailto:log4plsql-all-i= nfo...@li...] Envoy=E9 : lundi 17 mai 2004 16:51 =C0 : log...@li... Objet : [log4plsql] log4plsql Hi, What are the prerequisites for logplsql? Thanks & Regards, Ritu Kohli UBS Investment Bank Tel: +44-(0)20 7567 6806 Visit our website at http://www.ubs.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments. ------------------------------------------------------- This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up now for SourceForge Broadband and get the fastest 6.0/768 connection for only $19.95/mo for the first 3 months! http://ads.osdn.com/?ad_id%62&alloc_ida84&op=3Dick _______________________________________________ Log4plsql-all-info mailing list Log...@li... https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net |
|
From: log4plsql g. m. l. <log...@li...> - 2009-01-06 08:48:36
|
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 >> >> >> > > |
|
From: log4plsql g. m. l. <log...@li...> - 2009-01-07 14:33:37
|
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 >> >> >> >> >> > > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X