Monday, April 6, 2009

How to call a procedure using an OracleCallableStatement

OracleCallableStatement oracleCallableStatement = null;

try
{
oracleCallableStatement = (OracleCallableStatement)connection.prepareCall( YOUR_PROCEDURE );
oracleCallableStatement.setString( 1, VARIABLE_1 );
oracleCallableStatement.setString( 2, VARIABLE_2 );
oracleCallableStatement.setString( 3, VARIABLE_3 );
oracleCallableStatement.registerOutParameter(4, oracle.jdbc.OracleTypes.CURSOR);

oracleCallableStatement.execute();
rs = (ResultSet)oracleCallableStatement.getObject(4);
}
catch ( Exception e )
{
logerror("Error while setting up Oracle procedure. Error is: " + e.toString() );
fatalexit();
}

No comments:

Post a Comment