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=click _______________________________________________ Log4plsql-all-info mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net
