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
>>>
FUNCTION isDebugEnabled RETURN BOOLEAN IS BEGIN RETURN
islevelEnabled(getLevelInText('DEBUG')) ; END;
The new Modified Function which is Working is
>>> FUNCTION isDebugEnabled RETURN
BOOLEAN IS BEGIN RETURN islevelEnabled( getTextInLevel('DEBUG') ); END;
Changes:
Replaced getLevelInText('DEBUG') with
getTextInLevel('DEBUG')
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=1356&alloc_id=3438&op=click
_______________________________________________ Log4plsql-all-info mailing
list [EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq :
http://log4plsql.sourceforge.net
