RE : [log4plsql] LOG4PLSQL Error Version 3.1.b

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

Pascal,

TX for your update.

I make in 3.1.2.1 now in =
http://prdownloads.sourceforge.net/log4plsql/Log4plsql.zip

Regards,
Guillaume Moulard
gmo...@us...

Project : LOG4PLSQL : Oracle Database Loggin tools
see     : http://log4plsql.sourceforge.net/
 =20

  -----Message d'origine-----
  De : log...@li... =
[mailto:log...@li...]=20
  Envoy=E9 : jeudi 12 f=E9vrier 2004 09:51
  =C0 : Log...@li...
  Objet : [log4plsql] LOG4PLSQL Error Version 3.1.b


  Hi  all ,

  Thanks for your Efforts on the Log4PlSql  Project.


  I tried to use  LOG4PLSQL and got the following Error:

  >>Get the Version ::>>

  SQL> select plog.getLOG4PLSQVersion  as Version from dual  ;

  VERSION
  =
-------------------------------------------------------------------------=
-------
  3.1.b



  SQL> set serveroutput on size 1000000
  SQL> BEGIN
    2  IF Plog.isWarnEnabled THEN
    3  Plog.warn( ' warn raises Exception ') ;
    4  END IF ;
    5  END ;
    6  /
  BEGIN
  *
  FEHLER in Zeile 1:
  ORA-06502: PL/SQL: numeric or value error: character to number =
conversion error
  ORA-06512: at "LOG4PLSQL_USER.PLOG", line 757
  ORA-06512: at line 2



  I ! think the Problem lies in all the :  is*****Enabled  Functions :

   Proposed Solution :  I tried the following for  isDebugEnabled =
Procedure :

  The old  Function  with ERROR  is   >>>    =20

  FUNCTION   isDebugEnabled RETURN BOOLEAN IS BEGIN RETURN =
islevelEnabled(getLevelInText('DEBUG')) ; END;

  The new Modified Function which is Working   is=20

  >>>    FUNCTION   isDebugEnabled RETURN BOOLEAN IS BEGIN RETURN =
islevelEnabled( getTextInLevel('DEBUG') ); END;


  Changes:     Replaced   getLevelInText('DEBUG')   with   =
getTextInLevel('DEBUG')   =20


  I think the Function Names are also a bit Interchanged.


  Test with the New Modified Function is as follows :

  SQL> BEGIN
    2  IF Plog.isDebugEnabled THEN
    3&nbs! p; Plog.warn( ' Debug is Ok after Modification ') ;
    4  END IF ;
    5  END ;
    6  /

  PL/SQL-Prozedur wurde erfolgreich abgeschlossen.


  I hope others were also getting the same Error , or may be i did =
something wrong ?

  Sincerely Yours,

  Pascal  Mwakuye

  =
_________________________________________________________________________=
_____
  Erdbeben im Iran: Zehntausende Kinder brauchen Hilfe. UNICEF hilft den
  Kindern - helfen Sie mit! https://www.unicef.de/spe/spe_03.php =
------------------------------------------------------- SF.Net is =
sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & =
Web services for Linux with a free DVD software kit from IBM. Click Now! =
http://ads.osdn.com/?ad_id=3D1356&alloc_id=3D3438&op=3Dclick =
_______________________________________________ Log4plsql-all-info =
mailing list Log...@li... =
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq =
: http://log4plsql.sourceforge.net