execute Oracle SP's

[ccampbell]

I need to connect to an oracle database and execute 10 different stored procedures. Does anyone have a snippet of code that works good in Java for executing Oracle Stored Procedures? Or would anyone recommend another way to accomplish this? Right now I am executing Java code to import XML files into an Oracle database and then I am trying to execute .NET code to run the procedures. I would like to combine both processes to simplify things. Thanks in advance

 

[sedj]

Use a CallableStatement object, created from the Connection.prepareCall() method.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[4345487]

This is an example that I use to validate that the zip code, city, state are correct.

/* call the store procedure */
CallableStatement cs = con.prepareCall("{call validateZipCode(?, ?, ?, ?, ?)}");
cs.setString(1, city.toLowerCase());
cs.setString(2, region.toLowerCase());
cs.setString(3, country.toLowerCase());
cs.setString(4, newZip);
cs.registerOutParameter(5, Types.VARCHAR);
cs.execute(