All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class oracle.jdbc.driver.OracleCallableStatement 

java.lang.Object
   |
   +----oracle.jdbc.driver.OracleStatement
           |
           +----oracle.jdbc.driver.OraclePreparedStatement
                   |
                   +----oracle.jdbc.driver.OracleCallableStatement
public class OracleCallableStatement
extends OraclePreparedStatement
implements CallableStatement
Oracle callable statement.

Method Index

o addBatch()
Add a set of parameters to the batch.
o clearParameters()

In general, parameter values remain in force for repeated use of a Statement.

o getArray(int)
o getARRAY(int)
o getAsciiStream(int)
o getBFILE(int)
o getBigDecimal(int)
o getBigDecimal(int, int)
o getBinaryStream(int)
o getBlob(int)
o getBLOB(int)
o getBoolean(int)
o getByte(int)
o getBytes(int)
o getCHAR(int)
o getCLOB(int)
o getClob(int)
o getCursor(int)
o getCustomDatum(int, CustomDatumFactory)
o getDATE(int)
o getDate(int)
o getDate(int, Calendar)
o getDouble(int)
o getFloat(int)
o getInt(int)
o getLong(int)
o getNUMBER(int)
o getObject(int)
o getObject(int, Dictionary)
o getOracleObject(int)
o getRAW(int)
o getREF(int)
o getRef(int)
o getROWID(int)
o getShort(int)
o getString(int)
o getSTRUCT(int)
o getTime(int)
o getTime(int, Calendar)
o getTimestamp(int)
o getTimestamp(int, Calendar)
o getUnicodeStream(int)
o registerOutParameter(int, int)
o registerOutParameter(int, int, int)
o registerOutParameter(int, int, int, int)
Special Oracle version of registerOutParameter for registering CHAR, VARCHAR, LONG, RAW and LONG RAW columns.
o registerOutParameter(int, int, String)
Special Oracle version of registerOutParameter for registering Object columns.
o sendBatch()
Send the sets of parameters batched (for Oracle-style batching only).
o setExecuteBatch(int)
Set the batch value (for Oracle-style batching only).
o wasNull()

Methods

o registerOutParameter 
 public synchronized void registerOutParameter(int paramIndex,
                                               int sqlType,
                                               String sqlName) throws SQLException
Special Oracle version of registerOutParameter for registering Object columns.

Parameters:
paramIndex parameter - index.
sqlType use - OracleTypes.STRUCT, OracleTypes.ARRAY, or OracleTypes.REF.
sqlName SQL - name of the object.
Throws: SQLException
if sqlType is invalid, or an error occurred.
o registerOutParameter 
 public synchronized void registerOutParameter(int paramIndex,
                                               int sqlType,
                                               int scale,
                                               int maxLength) throws SQLException
Special Oracle version of registerOutParameter for registering CHAR, VARCHAR, LONG, RAW and LONG RAW columns.

Parameters:
paramIndex parameter - index (the first parameter is 1).
sqlType type - of the bind parameter,
scale not - used.
maxLength maximum - length of the column. If not specified, maximum length allowed for that type is used.
o setExecuteBatch 
 public synchronized void setExecuteBatch(int nrows) throws SQLException
Set the batch value (for Oracle-style batching only).

Oracle-style batching is not supported for a callable statement. This method always sets the batch value to 1.

Overrides:
setExecuteBatch in class OraclePreparedStatement
o sendBatch 
 public synchronized int sendBatch() throws SQLException
Send the sets of parameters batched (for Oracle-style batching only).

Oracle-style batching is not supported for a callable statement. This method simply returns the number of valid rows.

Overrides:
sendBatch in class OraclePreparedStatement
o registerOutParameter 
 public void registerOutParameter(int paramIndex,
                                  int sqlType) throws SQLException
o registerOutParameter 
 public void registerOutParameter(int paramIndex,
                                  int sqlType,
                                  int scale) throws SQLException
o wasNull 
 public boolean wasNull() throws SQLException
o getString 
 public String getString(int parameterIndex) throws SQLException
o getOracleObject 
 public Datum getOracleObject(int parameterIndex) throws SQLException
o getROWID 
 public ROWID getROWID(int parameterIndex) throws SQLException
o getNUMBER 
 public NUMBER getNUMBER(int parameterIndex) throws SQLException
o getDATE 
 public DATE getDATE(int parameterIndex) throws SQLException
o getREF 
 public REF getREF(int parameterIndex) throws SQLException
o getARRAY 
 public ARRAY getARRAY(int parameterIndex) throws SQLException
o getSTRUCT 
 public STRUCT getSTRUCT(int parameterIndex) throws SQLException
o getCHAR 
 public CHAR getCHAR(int parameterIndex) throws SQLException
o getRAW 
 public RAW getRAW(int parameterIndex) throws SQLException
o getBLOB 
 public BLOB getBLOB(int parameterIndex) throws SQLException
o getCLOB 
 public CLOB getCLOB(int parameterIndex) throws SQLException
o getBFILE 
 public BFILE getBFILE(int parameterIndex) throws SQLException
o getBoolean 
 public boolean getBoolean(int parameterIndex) throws SQLException
o getByte 
 public byte getByte(int parameterIndex) throws SQLException
o getShort 
 public short getShort(int parameterIndex) throws SQLException
o getInt 
 public int getInt(int parameterIndex) throws SQLException
o getLong 
 public long getLong(int parameterIndex) throws SQLException
o getFloat 
 public float getFloat(int parameterIndex) throws SQLException
o getDouble 
 public double getDouble(int parameterIndex) throws SQLException
o getBigDecimal 
 public BigDecimal getBigDecimal(int parameterIndex,
                                 int scale) throws SQLException
o getBytes 
 public byte[] getBytes(int parameterIndex) throws SQLException
o getDate 
 public Date getDate(int parameterIndex) throws SQLException
o getTime 
 public Time getTime(int parameterIndex) throws SQLException
o getTimestamp 
 public Timestamp getTimestamp(int parameterIndex) throws SQLException
o getAsciiStream 
 public InputStream getAsciiStream(int parameterIndex) throws SQLException
o getUnicodeStream 
 public InputStream getUnicodeStream(int parameterIndex) throws SQLException
o getBinaryStream 
 public InputStream getBinaryStream(int parameterIndex) throws SQLException
o getObject 
 public Object getObject(int parameterIndex) throws SQLException
o getCustomDatum 
 public Object getCustomDatum(int parameterIndex,
                              CustomDatumFactory factory) throws SQLException
o getCursor 
 public ResultSet getCursor(int parameterIndex) throws SQLException
o clearParameters 
 public synchronized void clearParameters() throws SQLException

In general, parameter values remain in force for repeated use of a Statement.

Overrides:
clearParameters in class OraclePreparedStatement
o getObject 
 public Object getObject(int parameterIndex,
                         Dictionary map) throws SQLException
o getRef 
 public Ref getRef(int parameterIndex) throws SQLException
o getBlob 
 public Blob getBlob(int parameterIndex) throws SQLException
o getClob 
 public Clob getClob(int parameterIndex) throws SQLException
o getArray 
 public Array getArray(int parameterIndex) throws SQLException
o getBigDecimal 
 public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
o getDate 
 public Date getDate(int parameterIndex,
                     Calendar cal) throws SQLException
o getTime 
 public Time getTime(int parameterIndex,
                     Calendar cal) throws SQLException
o getTimestamp 
 public Timestamp getTimestamp(int parameterIndex,
                               Calendar cal) throws SQLException
o addBatch 
 public void addBatch() throws SQLException
Add a set of parameters to the batch.

Throws: SQLException
if an error occurred. Note that stored procedures with out or inout parameters cannot be batched.
Overrides:
addBatch in class OraclePreparedStatement 
All Packages  Class Hierarchy  This Package  Previous  Next  Index