Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
11g Release 2 (11.2.2)

E21647-03


com.timesten.jdbc
Interface TimesTenCallableStatement

All Superinterfaces:
java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, TimesTenPreparedStatement, TimesTenStatement, java.sql.Wrapper

public interface TimesTenCallableStatement
extends java.sql.CallableStatement, TimesTenPreparedStatement

Field Summary

 

Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

 

Method Summary
 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.

 

Methods inherited from interface java.sql.CallableStatement
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, 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, 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, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

 

Methods inherited from interface com.timesten.jdbc.TimesTenPreparedStatement
getReturnResultSet, registerReturnParameter, registerReturnParameter, setPlsqlIndexTable

 

Methods inherited from interface com.timesten.jdbc.TimesTenStatement
getLobPrefetchSize, getQueryTimeThreshold, setLobPrefetchSize, setQueryTimeThreshold

 

Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, execute, 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, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

 

Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

 

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

 

Method Detail

getCursor

java.sql.ResultSet getCursor(int parameterIndex)
                             throws java.sql.SQLException
Get PL/SQL REF CURSOR as ResultSet
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
ResultSet
Throws:
java.sql.SQLException - if a database access error occurs
See Also:
ResultSet

getCursor

java.sql.ResultSet getCursor(java.lang.String parameterName)
                             throws java.sql.SQLException
Get PL/SQL REF CURSOR as ResultSet
Parameters:
parameterName - the name of the parameter
Returns:
ResultSet
Throws:
java.sql.SQLException - if a database access error occurs
See Also:
ResultSet

registerOutParameter

void registerOutParameter(int paramIndex,
                          int sqlType,
                          int ignore,
                          int maxLength)
                          throws java.sql.SQLException
Register out parameter. This extension lets you specify maximum length for variable length fields such as CHAR, VARCHAR.
Parameters:
paramIndex - the first parameter is 1, the second is 2, and so on
sqlType - 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.
Throws:
java.sql.SQLException - if a database access error occurs

registerIndexTableOutParameter

void registerIndexTableOutParameter(int paramIndex,
                                    int maxLen,
                                    int elemSqlType,
                                    int elemMaxLen)
                                    throws java.sql.SQLException
Register a PL/SQL index-by table as an OUT parameter
Parameters:
paramIndex - the first parameter is 1, the second is 2, and so on
maxLen - 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.
Throws:
java.sql.SQLException - if a database access error occurs

getPlsqlIndexTable

java.lang.Object getPlsqlIndexTable(int paramIndex)
                                    throws java.sql.SQLException
Get the value of a PLSQL index table parameter as a Java array. The type of the Java array will be the default Java object type corresponding to the element's SQL type, following the mapping for built-in types specified in the JDBC specification
Parameters:
paramIndex - the first parameter is 1, the second is 2, and so on
Returns:
Object holding the parameter value.
Throws:
java.sql.SQLException - if a database access or conversion error occurs

getPlsqlIndexTable

java.lang.Object getPlsqlIndexTable(int paramIndex,
                                    java.lang.Class<?> primitiveType)
                                    throws java.sql.SQLException
Get the value of a PLSQL index table parameter as a primitive array. 'primitiveType' specifies the return array type.
Parameters:
paramIndex - the first parameter is 1, the second is 2, and so on
primitiveType - is a primitive type class. For example, Double.TYPE
Returns:
An Object holding the parameter value.
Throws:
java.sql.SQLException - if a database access or conversion error occurs

Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
11g Release 2 (11.2.2)

E21647-03


Copyright © 1999, 2013, Oracle and/or its affiliates. All rights reserved.