RE: [log4plsql] Oracle 9i Forms

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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 packag=
e
in a Forms module Program Unit.  I haven't tried it in Forms 10g.

-Jerome

> -----Original Message-----
> From: log...@li...
> [mailto:log...@li...]
> Sent: Thursday, March 18, 2004 6:48 AM
> To: log...@li...
> 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=DA =D3 :
> 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=DAdure PL/SQL termin=DAe avec succ=DEs.
>
> SQL> DECLARE
>   2      logCtx plog.log_ctx :=3D plog.init(pLEVEL =3D> plog.LALL);
>   3  BEGIN
>   4      plog.debug(logCtx, 'Hi there from my forms package.');
>   5  END;
>   6  /
>
> Proc=DAdure PL/SQL termin=DAe avec succ=DEs.
>
> 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
> gmo...@us...
>
> Project : LOG4PLSQL : Oracle Database Loggin tools
> see : http://log4plsql.sourceforge.net/
> and :
> http://sourceforge.net/mailarchive/forum.php?forum=3Dlog4plsql-all-info=
 or
> http://www.mail-archive.com/log...@li...
> for  log...@li...
>
>
>
> -----Message d'origine-----
> De : log...@li...
> [mailto:log...@li...]
> Envoy=E9 : mercredi 17 mars 2004 20:10
> =C0 : log...@li...
> Objet : RE: [log4plsql] Oracle 9i Forms
>
>
>
> Hello,
>
>
>
> What I was trying to do is something like this in my Forms Client PL/SQ=
L
>
> package.
>
>
>
> <code_bad>
>
> logCtx plog.log_ctx :=3D plog.init(pLEVEL =3D> 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: log...@li...
>
> > [mailto:log...@li...]
>
> > Sent: Wednesday, March 17, 2004 1:23 PM
>
> > To: log...@li...
>
> > 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
>
> > gmo...@us...
>
> >
>
> > Project : LOG4PLSQL : Oracle Database Loggin tools
>
> > see : http://log4plsql.sourceforge.net/
>
> > and :
>
> > http://sourceforge.net/mailarchive/forum.php?forum=3Dlog4plsql-all-in=
fo or
>
> > http://www.mail-archive.com/log...@li...
>
> > for  log...@li...
>
> >
>
> > -----Message d'origine-----
>
> > De : log...@li...
>
> > [mailto:log...@li...]
>
> > Envoy=E9 : mercredi 17 mars 2004 14:39
>
> > =C0 : 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 remo=
te
>
> >
>
> > 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=3D1470&alloc_id=3D3638&op=3D=
click
>
> >
>
> > _______________________________________________
>
> >
>
> > Log4plsql-all-info mailing list
>
> >
>
> > Log...@li...
>
> >
>
> > 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_id=1470&alloc_id638&op=CCk
>
> > _______________________________________________
>
> > Log4plsql-all-info mailing list
>
> > Log...@li...
>
> > 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_id=1470&alloc_id638&op=3Dick
>
> _______________________________________________
>
> Log4plsql-all-info mailing list
>
> Log...@li...
>
> 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_id=1470&alloc_id638&op=CCk
> _______________________________________________
> Log4plsql-all-info mailing list
> Log...@li...
> https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
> log4plsq : http://log4plsql.sourceforge.net
>
>
>