Java Programming with Oracle JDBC

CallableStatement Is an OracleCallableStatement

The CallableStatement object used in this chapter’s examples is an interface. The full interface name is java.sql.CallableStatement. This interface is implemented by oracle.jdbc.driver.OracleCallableStatement, which extends oracle.jdbc.driver.OraclePreparedStatement. This means that all the proprietary methods that are available in OracleStatement and OraclePreparedStatement are also available in Oracle-CallableStatement. The following is a list of the proprietary methods available in OracleCallableStatement, all of which can throw a SQLException:

clearParameters(  )
ARRAY getARRAY(int parameterIndex)
InputStream getAsciiStream(int parameterIndex)
BFILE getBFILE(int parameterIndex)
InputStream getBinaryStream(int parameterIndex)
BLOB getBLOB(int parameterIndex)
CHAR getCHAR(int parameterIndex)
CLOB getCLOB(int parameterIndex)
ResultSet getCursor(int parameterIndex)
Object getCustomDatum(int parameterIndex, CustomDatumFactory factory)
DATE getDATE(int parameterIndex)
NUMBER getNUMBER(int parameterIndex)
Datum getOracleObject(int parameterIndex)
RAW getRAW(int parameterIndex)
REF getREF(int parameterIndex)
ROWID getROWID(int parameterIndex)
STRUCT getSTRUCT(int parameterIndex)
InputStream getUnicodeStream(int parameterIndex)
registerOutParameter(
 int paramIndex, int sqlType, int scale, int maxLength)