Call store procedures from Java

package cat.eix.exemples.exemple;
 
import java.sql.*;
import oracle.jdbc.OracleTypes;
 
public class CallProc {
 
  public static final String BDD = "jdbc:oracle:thin:@192.168.10.17:1521:ORA92";
  public static final String USR = "ICT";
  public static final String PWD = "ICT78";
 
  public CallProc() {
  }
 
  public static void main(String args []) throws SQLException  {
    Connection        conn = null;
    CallableStatement cstm = null;
    ResultSet         rset = null;
 
    try {
      // Carrega driver JDBC
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 
      // Connexio a BDD
      conn = DriverManager.getConnection (BDD, USR, PWD);
 
      //
      // Crida al procediment sense valors de retorn
      //
      System.out.println( "Crida al procés sense valors de retorn:" );
      cstm = conn.prepareCall("begin call_proc.proc1( ?, ?, ? ); end;");
      cstm.setString(1, "Cadena");             //Exemple varchar2
      cstm.setLong(2, 1000000);                //Exemple number
      cstm.setString(3, "21/11/1977");         //Exemple date       
 
      cstm.execute();
      System.out.println( "Procés executat." );
      System.out.println( "" );   
      cstm.close();      
 
      //
      //Crida funcio que retorna dos valors
      //
      System.out.println( "Crida funcio que retorna dos valors:" );
      cstm = conn.prepareCall("begin ? := call_proc.func1( ?, ?, ?); end;");
      cstm.registerOutParameter(1, Types.VARCHAR);        //Retorn
      cstm.registerOutParameter(4, Types.VARCHAR);        //Paràmtre OUT
      cstm.setString(2, "Cadena");                         //VARCHAR2
      cstm.setLong(3, 1000000);                            //NUMBER
 
      cstm.execute();
      System.out.println( "Procés executat." );      
 
      String vVC2_1 = cstm.getString(1);
      String vVC2_4 = cstm.getString(4);
      System.out.println( "VALOR RETORN: " + vVC2_1 + " PARAMETE OUT: " + vVC2_4 );
      System.out.println( "" );
      cstm.close();
 
      //
      //Funcio que retorna un cursor
      //
      System.out.println( "Funcio que retorna un cursor" );
      cstm = conn.prepareCall( "begin ? := call_proc.func2( ? ); end;" );
      cstm.registerOutParameter(1, OracleTypes.CURSOR);
      cstm.setLong(2, 10);
      cstm.execute();
 
      // Recuperar resultset
      rset = (ResultSet) cstm.getObject(1);
      System.out.println( "Cursor recuperat: " );
 
      while( rset.next() ) {
        System.out.println( "   " + rset.getString("object_id") + " - "  + rset.getString("object_name") );
      }
 
      rset.close();
      cstm.close();      
 
   } catch (SQLException e) {
     e.printStackTrace();
   } finally {
     System.out.println("Closing....");
     if (rset != null) { rset.close(); rset = null; }
     if (cstm != null) { cstm.close(); cstm = null; }
     if (conn != null) { conn.close(); conn = null; }
   }
  }
}