Hello Guillaume, Yes, that works in my sqlplus. It does not work as Forms 9i client side PL/SQL. For example, it doesn't work in a procedure, function, or package in a Forms module Program Unit. I haven't tried it in Forms 10g.
-Jerome > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 18, 2004 6:48 AM > To: [EMAIL PROTECTED] > Subject: RE: [log4plsql] Oracle 9i Forms > > > Jerome, > > I don't have problem with my small test case : > > > --------------------------------- > > SQL*Plus: Release 9.2.0.1.0 - Production on Je Mar 18 12:42:40 2004 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > > Connect� � : > Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.1.0 - Production > > SQL> select plog.getLOG4PLSQVersion from dual; > > GETLOG4PLSQVERSION > ------------------------------------------------------------------ > -------------- > 3.1.2.1 > > SQL> exec plog.purge > > Proc�dure PL/SQL termin�e avec succ�s. > > SQL> DECLARE > 2 logCtx plog.log_ctx := plog.init(pLEVEL => plog.LALL); > 3 BEGIN > 4 plog.debug(logCtx, 'Hi there from my forms package.'); > 5 END; > 6 / > > Proc�dure PL/SQL termin�e avec succ�s. > > SQL> select * from vlog; > > LOG > ------------------------------------------------------------------ > -------------- > [Mar 18, 12:43:16:82][INFO][ULOG][plog.purge][Purge by user:ULOG] > [Mar 18, 12:43:21:21][DEBUG][ULOG][ anonymous block][Hi there > from my forms pack > age.] > > > SQL> > > --------------------------------- > > This test case run in yours sqlplus? > > > Regards, > Guillaume Moulard > [EMAIL PROTECTED] > > Project : LOG4PLSQL : Oracle Database Loggin tools > see : http://log4plsql.sourceforge.net/ > and : > http://sourceforge.net/mailarchive/forum.php?forum=log4plsql-all-info or > http://www.mail-archive.com/[EMAIL PROTECTED] > for [EMAIL PROTECTED] > > > > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Envoy� : mercredi 17 mars 2004 20:10 > � : [EMAIL PROTECTED] > Objet : RE: [log4plsql] Oracle 9i Forms > > > > Hello, > > > > What I was trying to do is something like this in my Forms Client PL/SQL > > package. > > > > <code_bad> > > logCtx plog.log_ctx := plog.init(pLEVEL => plog.LALL); > > plog.debug(logCtx, 'Hi there from my forms package.'); > > </code_bad> > > > > However the above wouldn't compile. The following error was generated. > > > > <compile_error> > > Implementation Restriction: 'PLOG.LALL': Cannot directory access remote > > package variable or cursor. > > </compile_error> > > > > The client PL/SQL compiler does allow me to call the methods > without the log > > context. > > > > <code_good> > > plog.error('Hi there from my forms package.'); > > </code_good> > > > > If I make any more progress I'll share it on the list. > > > > Regards, > > > > Jerome Jacobsen > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, March 17, 2004 1:23 PM > > > To: [EMAIL PROTECTED] > > > Subject: RE: [log4plsql] Oracle 9i Forms > > > > > > > > > Hi, > > > > > > I don't have a Forms PL/SQL Library for PLOG > > > > > > > > > I think you can make calls for: > > > PROCEDURE debug > > > PROCEDURE info > > > PROCEDURE warn > > > PROCEDURE error > > > PROCEDURE fatal > > > PROCEDURE log > > > > > > With a lot of different parameter. But there is no > > > procedure/function for plog.LALL > > > If you whan use LALL, is necessary to use log procedure. > > > > > > I'm very interest if you whan share yours forms library. > > > > > > > > > Regards, > > > Guillaume Moulard > > > [EMAIL PROTECTED] > > > > > > Project : LOG4PLSQL : Oracle Database Loggin tools > > > see : http://log4plsql.sourceforge.net/ > > > and : > > > http://sourceforge.net/mailarchive/forum.php?forum=log4plsql-all-info or > > > http://www.mail-archive.com/[EMAIL PROTECTED] > > > for [EMAIL PROTECTED] > > > > > > -----Message d'origine----- > > > De : [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > > > Envoy� : mercredi 17 mars 2004 14:39 > > > � : Log4PlSql > > > Objet : [log4plsql] Oracle 9i Forms > > > > > > > > > > > > How can I use this in Client Side PL/SQL in Oracle 9i Forms? I'm > > > new to both > > > > > > Forms and Log4PlSql. > > > > > > > > > > > > Do I need to somehow create a Forms PL/SQL Library for PLOG? > > > > > > > > > > > > For now I'm able to make calls to the plog.debug, etc. procedures > > > that make > > > > > > use of the default context. However when I try to reference > > > plog.LALL I get > > > > > > an error in Forms Builder: > > > > > > > > > > > > Implementation Restriction: 'PLOG.LALL': Cannot directory access remote > > > > > > package variable or cursor. > > > > > > > > > > > > I assume this error will occur for the other Level package variables. > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > This SF.Net email is sponsored by: IBM Linux Tutorials > > > > > > Free Linux tutorial presented by Daniel Robbins, President and CEO of > > > > > > GenToo technologies. Learn everything from fundamentals to system > > > > > > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > > > > > > _______________________________________________ > > > > > > Log4plsql-all-info mailing list > > > > > > [EMAIL PROTECTED] > > > > > > https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info > > > > > > log4plsq : http://log4plsql.sourceforge.net > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.Net email is sponsored by: IBM Linux Tutorials > > > Free Linux tutorial presented by Daniel Robbins, President and CEO of > > > GenToo technologies. Learn everything from fundamentals to system > > > administration.http://ads.osdn.com/?ad_id70&alloc_id638&op�k > > > _______________________________________________ > > > Log4plsql-all-info mailing list > > > [EMAIL PROTECTED] > > > https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info > > > log4plsq : http://log4plsql.sourceforge.net > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: IBM Linux Tutorials > > Free Linux tutorial presented by Daniel Robbins, President and CEO of > > GenToo technologies. Learn everything from fundamentals to system > > administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=ick > > _______________________________________________ > > Log4plsql-all-info mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info > > log4plsq : http://log4plsql.sourceforge.net > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id70&alloc_id638&op�k > _______________________________________________ > Log4plsql-all-info mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info > log4plsq : http://log4plsql.sourceforge.net > > > ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click _______________________________________________ Log4plsql-all-info mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net
