public interface TimesTenCallableStatement extends java.sql.CallableStatement, TimesTenPreparedStatement
TimesTenPreparedStatement.PassThroughType
Modifier and Type | Method and Description |
---|---|
java.sql.ResultSet |
getCursor(int parameterIndex)
Get PL/SQL REF CURSOR as ResultSet
|
java.sql.ResultSet |
getCursor(java.lang.String parameterName)
Get PL/SQL REF CURSOR as ResultSet
|
java.lang.Object |
getPlsqlIndexTable(int paramIndex)
Get the value of a PLSQL index table parameter as a Java array.
|
java.lang.Object |
getPlsqlIndexTable(int paramIndex, java.lang.Class<?> primitiveType)
Get the value of a PLSQL index table parameter as a primitive array.
|
void |
registerIndexTableOutParameter(int paramIndex, int maxLen, int elemSqlType, int elemMaxLen)
Register a PL/SQL index-by table as an OUT parameter
|
void |
registerOutParameter(int paramIndex, int sqlType, int ignore, int maxLength)
Register out parameter.
|
getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull
getPassThroughType, getReturnResultSet, registerReturnParameter, registerReturnParameter, setPlsqlIndexTable
getLobPrefetchSize, getQueryTimeThreshold, setLobPrefetchSize, setQueryTimeThreshold
addBatch, clearParameters, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
java.sql.ResultSet getCursor(int parameterIndex) throws java.sql.SQLException
parameterIndex
- the first parameter is 1, the second is 2, and so onjava.sql.SQLException
- if a database access error occursResultSet
java.sql.ResultSet getCursor(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- the name of the parameterjava.sql.SQLException
- if a database access error occursResultSet
void registerOutParameter(int paramIndex, int sqlType, int ignore, int maxLength) throws java.sql.SQLException
paramIndex
- the first parameter is 1, the second is 2, and so onsqlType
- the SQL type code defined by java.sql.Types.ignore
- Not used.maxLength
- maximum length of the column, specified in bytes for BINARY/VARBINARY fields and in characters for CHAR/VARCHAR fields.java.sql.SQLException
- if a database access error occursvoid registerIndexTableOutParameter(int paramIndex, int maxLen, int elemSqlType, int elemMaxLen) throws java.sql.SQLException
paramIndex
- the first parameter is 1, the second is 2, and so onmaxLen
- the maximum possible number of elements.elemSqlType
- index table element SQL type (as defined in java.sql.Types or TimesTenTypes).elemMaxLen
- maximum length of the element. If not specified, maximum length allowed for that type is used.java.sql.SQLException
- if a database access error occursjava.lang.Object getPlsqlIndexTable(int paramIndex) throws java.sql.SQLException
paramIndex
- the first parameter is 1, the second is 2, and so onjava.sql.SQLException
- if a database access or conversion error occursjava.lang.Object getPlsqlIndexTable(int paramIndex, java.lang.Class<?> primitiveType) throws java.sql.SQLException
paramIndex
- the first parameter is 1, the second is 2, and so onprimitiveType
- is a primitive type class. For example, Double.TYPEjava.sql.SQLException
- if a database access or conversion error occurs