OraclePreparedStatement

Extends the java.sql.PreparedStatement interface with Oracle9i; extends OracleStatement with Oracle8i. With Oracle8i, implements oracle.jdbc.internal.OraclePreparedStatement.

Fields

FORM_CHAR
Static short, new with Oracle9i
FORM_NCHAR
Static short, new with Oracle9i

Inherited fields

The following fields are inherited from oracle.jdbc.OracleStatement:

auto_rollback
Only with Oracle8i
closed
Only with Oracle8i
dbstmt
Only with Oracle8i
defines
Only with Oracle8i
EXPLICIT
IMPLICIT
NEW
wait_option
Only with Oracle8i.

Methods

closeWithKey(java.lang.String key )

The underlying cursor is not closed and the statement handle is cached on the key, while the state, data, and metadata are not cleared. The statement can be retrieved with this key later. Oracle8i only.

defineParameterType(int param_index , int type , int max_size )

Defines the type under which you will bind the parameter and the maximum size (in characters) of data you will bind in binds.

defineParameterTypeBytes(int param_index , int type , int max_size )

Defines the type under which you will bind the parameter and the maximum size (in bytes) of data you will bind in binds. New with Oracle9i.

defineParameterTypeChars(int param_index , int type , int max_size )

Defines the type under which you will bind the parameter and the maximum size (in characters) of data you will bind in binds. New with Oracle9i.

getExecuteBatch( )

Retrieves the int batch value of this statement for ...

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial