Abgeschickt von Daniel am 12 Januar, 2005 um 13:39:11
Antwort auf: SET_ROLE in the log4j.properties von Daniel am 11 Januar, 2005 um 17:45:44:
I fixed it... it was a query problem... execute just works 1 query command.... I changed to a begin-end, thus getting a whole script work.
Here how the line was modified to work:
log4j.appender.R.sql=begin DBMS_SESSION.SET_ROLE('RL_DATA');INSERT INTO SN_TB_LOGS_TOMCAT (DATE, MOD, ERROR_MENSAGE) VALUES (SYSDATE, '%l', '%m');end;
Thanks, anyway! =o)