java.sql.Connection connection = null;
    CallableStatement proc = null;
    try {
               Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
               String url = "jdbc:oracle:thin:@localhost:1521:SID";
               connection = DriverManager.getConnection(url, username, password);
               proc = connection.prepareCall("{ call sp_check_bank_by_bankid(?,?,?)} ");
               proc.setString(1, bankAcct);
               proc.setString(2, bankId);
               proc.registerOutParameter(3,java.sql.Types.CHAR);
               proc.execute();               String retStr=proc.getString(3);    }
    catch (Exception e1) {
      e1.printStackTrace();
    }
    finally{
        try {
          if(proc!=null)
               proc.close();
          if(connection!=null)
               connection.close();
          }
         catch (SQLException e2) {
               e2.printStackTrace();
          }
    }