Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
Release 11.2.1

E13083-02


com.timesten.jdbc
Interface TimesTenCallableStatement

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

public interface TimesTenCallableStatement
extends java.sql.CallableStatement

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
 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 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 - 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

Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
Release 11.2.1

E13083-02


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