RE: [log4plsql] Oracle 9i Forms

[<log...@li...>]

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-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 : 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/SQL

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 lo=
g

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-info o=
r

> 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 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=3D1470&alloc_id=3D3638&op=3Dcli=
ck

>

> _______________________________________________

>

> 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