[log4plsql] LOG4PLSQL Error Version 3.1.b

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

<html><style>p {margin: 0px}</style><body bgcolor='#ffffff' style='font-size:9pt; font-family:Verdana; font-family: Verdana' >Hi&nbsp; all ,Thanks for your Efforts on the Log4PlSql&nbsp; Project. I tried to use&nbsp; LOG4PLSQL and got the following Error:&gt;&gt;Get the Version ::&gt;&gt;SQL&gt; select plog.getLOG4PLSQVersion&nbsp; as Version from dual&nbsp; ;VERSION -------------------------------------------------------------------------------- 3.1.bSQL&gt; set serveroutput on size 1000000 SQL&gt; BEGIN &nbsp; 2&nbsp; IF Plog.isWarnEnabled THEN &nbsp; 3&nbsp; Plog.warn( ' warn raises Exception ') ; &nbsp; 4&nbsp; END IF ; &nbsp; 5&nbsp; END ; &nbsp; 6&nbsp; / 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&nbsp;I !
 think the Problem lies in all the :&nbsp; is*****Enabled&nbsp; Functions :&nbsp;Proposed Solution :&nbsp; I tried the following for&nbsp; isDebugEnabled Procedure :The old&nbsp; Function&nbsp; with ERROR&nbsp; is&nbsp;&nbsp; &gt;&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp; FUNCTION&nbsp;&nbsp; isDebugEnabled RETURN BOOLEAN IS BEGIN RETURN islevelEnabled(getLevelInText('DEBUG')) ; END;The new Modified Function which is Working&nbsp;&nbsp; is &gt;&gt;&gt;&nbsp;&nbsp;&nbsp; FUNCTION&nbsp;&nbsp; isDebugEnabled RETURN BOOLEAN IS BEGIN RETURN islevelEnabled( getTextInLevel('DEBUG') ); END; Changes:&nbsp;&nbsp;&nbsp;&nbsp; Replaced&nbsp;&nbsp;&nbsp;getLevelInText('DEBUG')&nbsp;&nbsp; with&nbsp;&nbsp; getTextInLevel('DEBUG')&nbsp;&nbsp;&nbsp; I think the Function Names are also a bit Interchanged. Test with the New Modified Function is as follows :SQL&gt; BEGIN &nbsp; 2&nbsp; IF Plog.isDebugEnabled THEN &nbsp; 3&nbs!
 p; Plog.warn( ' Debug is Ok after Modification ') ; &nbsp; 4&nbsp; 
END IF ; &nbsp; 5&nbsp; END ; &nbsp; 6&nbsp; /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&nbsp; Mwakuye</body></html>
______________________________________________________________________________ Erdbeben im Iran: Zehntausende Kinder brauchen Hilfe. UNICEF hilft den Kindern - helfen Sie mit! https://www.unicef.de/spe/spe_03.php