Abgeschickt von Nadia Kunkov am 01 November, 2005 um 23:36:31
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