import java.io.*;
import java.sql.*;

/**
 * Calls a stored procedure and prints some results.
 */
public class StoredProcedureCall {

   public static void main(String[] args) {

      Connection conn = null;
      CallableStatement cstmt = null;

      // Load the database driver.

      try {

         Class.forName("oracle.jdbc.driver.OracleDriver");

      } catch (ClassNotFoundException e) {

         System.out.println("Driver class was not found.");
         return;

      } // end try block

      // connect to the database

      try {

         // your.db.server.com = the name of your database server
         // dbUserName = database username
         // dbPassword = password for database user

         conn = DriverManager.getConnection(
            "jdbc:oracle:thin:@your.db.server.com:123:dwch",
            "dbUserName",
            "dbPassword" );

         cstmt = conn.prepareCall("{?=call GETBOOKID(?)}");
         cstmt.registerOutParameter(1, java.sql.Types.INTEGER);
         cstmt.setString(2, "The Big Sleep");
         cstmt.execute();
         
         System.out.println("The ID for _The Big Sleep_ is " + cstmt.getInt(1));

        } catch (SQLException eSQL) {

         System.out.println(eSQL.getMessage());
         return;

      } finally {

         try {
            cstmt.close();
            conn.close();
         } catch (Exception e) {}

      } // end try 

   } // end main

} // StoredProcedureCall