import oracle.jdbc.OracleCallableStatement;
import oracle.jdbc.OracleConnection;
import oracle.jdbc.OracleTypes;
import oracle.jdbc.oracore.OracleType;
import org.hibernate.jdbc.Work;
 
 
public class MyWork implements Work {
 
  @Override
  public void execute(Connection connection) throws SQLException {
     oracle.jdbc.driver.OracleConnection oracleConn = (oracle.jdbc.driver.OracleConnection) connection.getMetaData().getConnection();
     final OracleCallableStatement storedProc = (OracleCallableStatement) oracleConn.prepareCall("{Call ...}");
     ....
  }
}