Abgeschickt von Danko am 16 November, 2005 um 08:50:17:
Antwort auf: Passing Parameters to Stored Procedure von Nadia Kunkov am 01 November, 2005 um 23:36:31:
Hello,
sorry for the late answer, I have been busy lately.
In order to fill the parameters you also have to set some column options.
In xml it is done like this:
http://www.mannhaupt.com/danko/projects/jdbcappender/src/org/apache/log4j/jdbcplus/examples/test/log4j_test_storedproc.xml
You need to call a few times
ja.setColumn(...);
Hope that helps,
Danko
: Hello,
: I was wondering if you could help me and sorry if the question is dumb.
: I need to pass parameters to my stored procedure from within the java code.
: Here is what I have:
: JDBCAppender ja = new JDBCAppender();
: Logger logger = Logger.getLogger
: (FLogger.class);
: ja.setUrl("jdbc:oracle:thin:@mydb:1521:mysid");
: ja.setDbclass("oracle.jdbc.driver.OracleDriver");
: ja.setUsername("myID");
: ja.setPassword("myPassword");
: ja.setProcedure("mypackage.mystoredProcName");
: logger.addAppender(ja);
: logger.info("");
: Now, how would I pass parameters to my stored proc?
: I would greatly appreciate your help.
: Thank you
: Nadia