|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Fields inherited from class oracle.jdbc.OraclePreparedStatement |
FORM_CHAR, FORM_NCHAR |
Fields inherited from class oracle.jdbc.OracleStatement |
EXPLICIT, IMPLICIT, NEW |
Method Summary | |
ARRAY |
getARRAY(int parameterIndex) |
java.io.InputStream |
getAsciiStream(int parameterIndex) |
BFILE |
getBFILE(int parameterIndex) |
java.io.InputStream |
getBinaryStream(int parameterIndex) |
BLOB |
getBLOB(int parameterIndex) |
CHAR |
getCHAR(int parameterIndex) |
CLOB |
getCLOB(int parameterIndex) |
java.sql.ResultSet |
getCursor(int parameterIndex) |
java.lang.Object |
getCustomDatum(int parameterIndex, CustomDatumFactory factory) Deprecated. |
DATE |
getDATE(int parameterIndex) |
NUMBER |
getNUMBER(int parameterIndex) |
OPAQUE |
getOPAQUE(int parameterIndex) |
Datum |
getOracleObject(int parameterIndex) |
Datum[] |
getOraclePlsqlIndexTable(int paramIndex) Oracle OCI driver specific. |
java.lang.Object |
getORAData(int parameterIndex, ORADataFactory factory) |
java.lang.Object |
getPlsqlIndexTable(int paramIndex) Oracle OCI driver specific. |
java.lang.Object |
getPlsqlIndexTable(int paramIndex, java.lang.Class primitiveType) Oracle OCI driver specific. |
RAW |
getRAW(int parameterIndex) |
REF |
getREF(int parameterIndex) |
ROWID |
getROWID(int parameterIndex) |
STRUCT |
getSTRUCT(int parameterIndex) |
TIMESTAMP |
getTIMESTAMP(int paramIdx) Obtains an ouput oracle.sql.TIMESTAMP value. |
TIMESTAMPLTZ |
getTIMESTAMPLTZ(int paramIdx) Obtains an ouput oracle.sql.TIMESTAMPLTZ value. |
TIMESTAMPTZ |
getTIMESTAMPTZ(int paramIdx) Obtains an ouput oracle.sql.TIMESTAMPTZ value. |
java.io.InputStream |
getUnicodeStream(int parameterIndex) |
void |
registerIndexTableOutParameter(int paramIndex, int maxLen, int elemSqlType, int elemMaxLen) Oracle OCI driver specific. |
void |
registerOutParameter(int paramIndex, int sqlType, int scale, int maxLength) Special Oracle version of registerOutParameter for registering CHAR, VARCHAR, LONG, RAW and LONG RAW columns. |
int |
sendBatch() Send the sets of parameters batched (for Oracle-style batching only). |
void |
setExecuteBatch(int nrows) Set the batch value (for Oracle-style batching only). |
Methods inherited from interface java.sql.CallableStatement |
getArray, getBigDecimal, getBigDecimal, getBlob, getBoolean, getByte, getBytes, getClob, getDate, getDate, getDouble, getFloat, getInt, getLong, getObject, getObject, getRef, getShort, getString, getTime, getTime, getTimestamp, getTimestamp, registerOutParameter, registerOutParameter, registerOutParameter, wasNull |
Methods inherited from interface oracle.jdbc.OraclePreparedStatement |
defineParameterType, getExecuteBatch, setARRAY, setBfile, setBFILE, setBLOB, setCHAR, setCheckBindTypes, setCLOB, setCursor, setCustomDatum, setDATE, setDisableStmtCaching, setFixedCHAR, setFormOfUse, setNUMBER, setOPAQUE, setOracleObject, setORAData, setPlsqlIndexTable, setRAW, setREF, setRefType, setROWID, setSTRUCT, setStructDescriptor, setTIMESTAMP, setTIMESTAMPLTZ, setTIMESTAMPTZ |
Methods inherited from interface oracle.jdbc.OracleStatement |
clearDefines, closeWithKey, creationState, defineColumnType, defineColumnType, defineColumnType, defineColumnTypeChars, getRowPrefetch, setResultSetCache, setRowPrefetch |
Method Detail |
public ARRAY getARRAY(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public java.io.InputStream getAsciiStream(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public BFILE getBFILE(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public java.io.InputStream getBinaryStream(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public BLOB getBLOB(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public CHAR getCHAR(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public CLOB getCLOB(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public java.sql.ResultSet getCursor(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public java.lang.Object getCustomDatum(int parameterIndex, CustomDatumFactory factory) throws java.sql.SQLException
parameterIndex
-factory
-public java.lang.Object getORAData(int parameterIndex, ORADataFactory factory) throws java.sql.SQLException
parameterIndex
-factory
-public DATE getDATE(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public NUMBER getNUMBER(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public OPAQUE getOPAQUE(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public Datum getOracleObject(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public RAW getRAW(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public REF getREF(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public ROWID getROWID(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public STRUCT getSTRUCT(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public TIMESTAMP getTIMESTAMP(int paramIdx) throws java.sql.SQLException
paramIdx
- parameter index.public TIMESTAMPTZ getTIMESTAMPTZ(int paramIdx) throws java.sql.SQLException
paramIdx
- parameter index.public TIMESTAMPLTZ getTIMESTAMPLTZ(int paramIdx) throws java.sql.SQLException
paramIdx
- parameter index.public java.io.InputStream getUnicodeStream(int parameterIndex) throws java.sql.SQLException
parameterIndex
-public void registerOutParameter(int paramIndex, int sqlType, int scale, int maxLength) throws java.sql.SQLException
paramIndex
- parameter index (the first parameter is 1).sqlType
- type of the bind parameterscale
- not usedmaxLength
- maximum length of the column. If not specified, maximum length allowed for that type is used.public int sendBatch() throws java.sql.SQLException
Oracle-style batching is not supported for a callable statement. This method simply returns the number of valid rows.
public void setExecuteBatch(int nrows) throws java.sql.SQLException
Oracle-style batching is not supported for a callable statement. This method always sets the batch value to 1.
public java.lang.Object getPlsqlIndexTable(int paramIndex) throws java.sql.SQLException
columnIndex
- the first column is 1, the second is 2, ...public java.lang.Object getPlsqlIndexTable(int paramIndex, java.lang.Class primitiveType) throws java.sql.SQLException
columnIndex
- the first column is 1, the second is 2, ...primitiveType
- is a primitive type class. For example,java.lang.Double.Typepublic Datum[] getOraclePlsqlIndexTable(int paramIndex) throws java.sql.SQLException
columnIndex
- the first column is 1, the second is 2, ...public void registerIndexTableOutParameter(int paramIndex, int maxLen, int elemSqlType, int elemMaxLen) throws java.sql.SQLException
paramIndex
- parameter index.maxLen
- the maximum possible number of elements.curLen
- the current number of elementselemSqlType
- index table element SQL type (as defined in java.sql.Types or OracleTypes).elemMaxLen
- maximum length of the element. If not specified, maximum length allowed for that type is used.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |