Abgeschickt von Danko am 13 Januar, 2005 um 09:16:12:
Antwort auf: Re: SET_ROLE in the log4j.properties von Daniel am 12 Januar, 2005 um 13:39:11:
You're welcome ;-)
Good to know when I have a similar problem.
Danko
: 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)