Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page