A JDBC Error Messages

This appendix briefly discusses the general structure of JDBC error messages, then lists general JDBC error messages and TTC error messages that the Oracle JDBC drivers can return. The appendix is organized as follows:

General Structure of JDBC Error Messages
General JDBC Messages
HeteroRM XA Messages
TTC Messages

Each of the message lists is first sorted by ORA number, and then alphabetically.

For general information about processing JDBC exceptions, see "Processing SQL Exceptions".

General Structure of JDBC Error Messages

The general JDBC error message structure allows runtime information to be appended to the end of a message, following a colon, as follows:

<error_message>:<extra_info>

For example, a "closed statement" error might be output as follows:

Closed Statement:next

This indicates that the exception was thrown during a call to the next() method (of a result set object).

In some cases, the user can find the same information in a stack trace.

General JDBC Messages

This section lists general JDBC error messages, first sorted by ORA number, and then alphabetically.

JDBC Messages Sorted by ORA Number

ORA Number	Message
`ORA-17001`	`Internal Error`
`ORA-17002`	`Io exception`
`ORA-17003`	`Invalid column index`
`ORA-17004`	`Invalid column type`
`ORA-17005`	`Unsupported column type`
`ORA-17006`	`Invalid column name`
`ORA-17007`	`Invalid dynamic column`
`ORA-17008`	`Closed Connection`
`ORA-17009`	`Closed Statement`
`ORA-17010`	`Closed Resultset`
`ORA-17011`	`Exhausted Resultset`
`ORA-17012`	`Parameter Type Conflict`
`ORA-17014`	`ResultSet.next was not called`
`ORA-17015`	`Statement was cancelled`
`ORA-17016`	`Statement timed out`
`ORA-17017`	`Cursor already initialized`
`ORA-17018`	`Invalid cursor`
`ORA-17019`	`Can only describe a query`
`ORA-17020`	`Invalid row prefetch`
`ORA-17021`	`Missing defines`
`ORA-17022`	`Missing defines at index`
`ORA-17023`	`Unsupported feature`
`ORA-17024`	`No data read`
`ORA-17025`	`Error in defines.isNull ()`
`ORA-17026`	`Numeric Overflow`
`ORA-17027`	`Stream has already been closed`
`ORA-17028`	`Can not do new defines until the current ResultSet is closed`
`ORA-17029`	`setReadOnly: Read-only connections not supported`
`ORA-17030`	`READ_COMMITTED and SERIALIZABLE are the only valid transaction levels`
`ORA-17031`	`setAutoClose: Only support auto close mode on`
`ORA-17032`	`cannot set row prefetch to zero`
`ORA-17033`	`Malformed SQL92 string at position`
`ORA-17034`	`Non supported SQL92 token at position`
`ORA-17035`	`Character Set Not Supported !!`
`ORA-17036`	`exception in OracleNumber`
`ORA-17037`	`Fail to convert between UTF8 and UCS2`
`ORA-17038`	`Byte array not long enough`
`ORA-17039`	`Char array not long enough`
`ORA-17040`	`Sub Protocol must be specified in connection URL`
`ORA-17041`	`Missing IN or OUT parameter at index:`
`ORA-17042`	`Invalid Batch Value`
`ORA-17043`	`Invalid stream maximum size`
`ORA-17044`	`Internal error: Data array not allocated`
`ORA-17045`	`Internal error: Attempt to access bind values beyond the batch value`
`ORA-17046`	`Internal error: Invalid index for data access`
`ORA-17047`	`Error in Type Descriptor parse`
`ORA-17048`	`Undefined type`
`ORA-17049`	`Inconsistent java and sql object types`
`ORA-17050`	`no such element in vector`
`ORA-17051`	`This API cannot be be used for non-UDT types`
`ORA-17052`	`This ref is not valid`
`ORA-17053`	`The size is not valid`
`ORA-17054`	`The LOB locator is not valid`
`ORA-17055`	`Invalid character encountered in`
`ORA-17056`	`Non supported character set (add orai18n.jar in your classpath)`
`ORA-17057`	`Closed LOB`
`ORA-17058`	`Internal error: Invalid NLS Conversion ratio`
`ORA-17059`	`Fail to convert to internal representation`
`ORA-17060`	`Fail to construct descriptor`
`ORA-17061`	`Missing descriptor`
`ORA-17062`	`Ref cursor is invalid`
`ORA-17063`	`Not in a transaction`
`ORA-17064`	`Invalid Sytnax or Database name is null`
`ORA-17065`	`Conversion class is null`
`ORA-17066`	`Access layer specific implementation needed`
`ORA-17067`	`Invalid Oracle URL specified`
`ORA-17068`	`Invalid argument(s) in call`
`ORA-17069`	`Use explicit XA call`
`ORA-17070`	`Data size bigger than max size for this type`
`ORA-17071`	`Exceeded maximum VARRAY limit`
`ORA-17072`	`Inserted value too large for column`
`ORA-17073`	`Logical handle no longer valid`
`ORA-17074`	`invalid name pattern`
`ORA-17075`	`Invalid operation for forward only resultset`
`ORA-17076`	`Invalid operation for read only resultset`
`ORA-17077`	`Fail to set REF value`
`ORA-17078`	`Cannot do the operation as connections are already opened`
`ORA-17079`	`User credentials doesn't match the existing ones`
`ORA-17080`	`invalid batch command`
`ORA-17081`	`error occurred during batching`
`ORA-17082`	`No current row`
`ORA-17083`	`Not on the insert row`
`ORA-17084`	`Called on the insert row`
`ORA-17085`	`Value conflicts occurs`
`ORA-17086`	`Undefined column value on the insert row`
`ORA-17087`	`Ignored performance hint: setFetchDirection()`
`ORA-17088`	`Unsupported syntax for requested resultset type and concurrency level`
`ORA-17089`	`internal error`
`ORA-17090`	`operation not allowed`
`ORA-17091`	`Unable to create resultset at the requested type and/or concurrency level`
`ORA-17092`	`JDBC statements cannot be created or executed at end of call processing`
`ORA-17093`	`OCI operation returned OCI_SUCCESS_WITH_INFO`
`ORA-17094`	`Object type version mismatched`
`ORA-17095`	`Statement Caching is not enabled for this Connection object`
`ORA-17096`	`Statement Caching cannot be enabled for this logical connection`
`ORA-17097`	`Invalid PL/SQL Index Table element type`
`ORA-17098`	`Invalid empty lob operation`
`ORA-17099`	`Invalid PL/SQL Index Table array length`
`ORA-17100`	`Invalid database Java Object`
`ORA-17101`	`Invalid properties in OCI Connection Pool Object`
`ORA-17102`	`Bfile is read only`
`ORA-17103`	`invalid connection type to return via getConnection. Use getJavaSqlConnection instead`
`ORA-17104`	`SQL statement to execute cannot be empty or null`
`ORA-17105`	`connection session time zone was not set`
`ORA-17106`	`invalid combination of connections specified`
`ORA-17107`	`invalid proxy type specified`
`ORA-17108`	`No max length specified in defineColumnType`
`ORA-17109`	`standard Java character encoding not found`
`ORA-17110`	`execution completed with warning`
`ORA-17111`	`Invalid connection cache TTL timeout specified`
`ORA-17112`	`Invalid thread interval specified`
`ORA-17113`	`Thread interval value is more than the cache timeout value`
`ORA-17114`	`could not use local transaction commit in a global transaction`
`ORA-17115`	`could not use local transaction rollback in a global transaction`
`ORA-17116`	`could not turn on auto-commit in an active global transaction`
`ORA-17117`	`could not set savepoint in an active global transaction`
`ORA-17118`	`could not obtain ID for a named Savepoint`
`ORA-17119`	`could not obtain name for an un-named Savepoint`
`ORA-17120`	`could not set a Savepoint with auto-commit on`
`ORA-17121`	`could not rollback to a Savepoint with auto-commit on`
`ORA-17122`	`could not rollback to a local txn Savepoint in a global transaction`
`ORA-17123`	`Invalid statement cache size specified`
`ORA-17124`	`Invalid connection cache Inactivity timeout specified`
`ORA-17125`	`Improper statement type returned by explicit cache`
`ORA-17126`	`Fixed Wait timeout elapsed`
`ORA-17127`	`Invalid Fixed Wait timeout specified`

JDBC Messages Sorted Alphabetically

ORA Number	Message
`ORA-17066`	`Access layer specific implementation needed`
`ORA-17102`	`Bfile is read only`
`ORA-17038`	`Byte array not long enough`
`ORA-17084`	`Called on the insert row`
`ORA-17028`	`Can not do new defines until the current ResultSet is closed`
`ORA-17019`	`Can only describe a query`
`ORA-17078`	`Cannot do the operation as connections are already opened`
`ORA-17032`	`cannot set row prefetch to zero`
`ORA-17039`	`Char array not long enough`
`ORA-17035`	`Character Set Not Supported !!`
`ORA-17008`	`Closed Connection`
`ORA-17057`	`Closed LOB`
`ORA-17010`	`Closed Resultset`
`ORA-17009`	`Closed Statement`
`ORA-17105`	`connection session time zone was not set`
`ORA-17065`	`Conversion class is null`
`ORA-17118`	`could not obtain ID for a named Savepoint`
`ORA-17119`	`could not obtain name for an un-named Savepoint`
`ORA-17122`	`could not rollback to a local txn Savepoint in a global transaction`
`ORA-17121`	`could not rollback to a Savepoint with auto-commit on`
`ORA-17120`	`could not set a Savepoint with auto-commit on`
`ORA-17117`	`could not set savepoint in an active global transaction`
`ORA-17116`	`could not turn on auto-commit in an active global transaction`
`ORA-17114`	`could not use local transaction commit in a global transaction`
`ORA-17115`	`could not use local transaction rollback in a global transaction`
`ORA-17017`	`Cursor already initialized`
`ORA-17070`	`Data size bigger than max size for this type`
`ORA-17025`	`Error in defines.isNull ()`
`ORA-17047`	`Error in Type Descriptor parse`
`ORA-17081`	`error occurred during batching`
`ORA-17071`	`Exceeded maximum VARRAY limit`
`ORA-17036`	`exception in OracleNumber`
`ORA-17110`	`execution completed with warning`
`ORA-17011`	`Exhausted Resultset`
`ORA-17060`	`Fail to construct descriptor`
`ORA-17037`	`Fail to convert between UTF8 and UCS2`
`ORA-17059`	`Fail to convert to internal representation`
`ORA-17077`	`Fail to set REF value`
`ORA-17126`	`Fixed Wait timeout elapsed`
`ORA-17087`	`Ignored performance hint: setFetchDirection()`
`ORA-17125`	`Improper statement type returned by explicit cache`
`ORA-17049`	`Inconsistent java and sql object types`
`ORA-17072`	`Inserted value too large for column`
`ORA-17089`	`internal error`
`ORA-17001`	`Internal Error`
`ORA-17045`	`Internal error: Attempt to access bind values beyond the batch value`
`ORA-17044`	`Internal error: Data array not allocated`
`ORA-17046`	`Internal error: Invalid index for data access`
`ORA-17058`	`Internal error: Invalid NLS Conversion ratio`
`ORA-17068`	`Invalid argument(s) in call`
`ORA-17080`	`invalid batch command`
`ORA-17042`	`Invalid Batch Value`
`ORA-17055`	`Invalid character encountered in`
`ORA-17003`	`Invalid column index`
`ORA-17006`	`Invalid column name`
`ORA-17004`	`Invalid column type`
`ORA-17106`	`invalid combination of connections specified`
`ORA-17124`	`Invalid connection cache Inactivity timeout specified`
`ORA-17111`	`Invalid connection cache TTL timeout specified`
`ORA-17103`	`invalid connection type to return via getConnection. Use getJavaSqlConnection instead`
`ORA-17018`	`Invalid cursor`
`ORA-17100`	`Invalid database Java Object`
`ORA-17007`	`Invalid dynamic column`
`ORA-17098`	`Invalid empty lob operation`
`ORA-17127`	`Invalid Fixed Wait timeout specified`
`ORA-17074`	`invalid name pattern`
`ORA-17075`	`Invalid operation for forward only resultset`
`ORA-17076`	`Invalid operation for read only resultset`
`ORA-17067`	`Invalid Oracle URL specified`
`ORA-17099`	`Invalid PL/SQL Index Table array length`
`ORA-17097`	`Invalid PL/SQL Index Table element type`
`ORA-17101`	`Invalid properties in OCI Connection Pool Object`
`ORA-17107`	`invalid proxy type specified`
`ORA-17020`	`Invalid row prefetch`
`ORA-17123`	`Invalid statement cache size specified`
`ORA-17043`	`Invalid stream maximum size`
`ORA-17064`	`Invalid Sytnax or Database name is null`
`ORA-17112`	`Invalid thread interval specified`
`ORA-17002`	`Io exception`
`ORA-17092`	`JDBC statements cannot be created or executed at end of call processing`
`ORA-17073`	`Logical handle no longer valid`
`ORA-17033`	`Malformed SQL92 string at position`
`ORA-17021`	`Missing defines`
`ORA-17022`	`Missing defines at index`
`ORA-17061`	`Missing descriptor`
`ORA-17041`	`Missing IN or OUT parameter at index:`
`ORA-17082`	`No current row`
`ORA-17024`	`No data read`
`ORA-17108`	`No max length specified in defineColumnType`
`ORA-17050`	`no such element in vector`
`ORA-17056`	`Non supported character set`
`ORA-17034`	`Non supported SQL92 token at position`
`ORA-17063`	`Not in a transaction`
`ORA-17083`	`Not on the insert row`
`ORA-17026`	`Numeric Overflow`
`ORA-17094`	`Object type version mismatched`
`ORA-17093`	`OCI operation returned OCI_SUCCESS_WITH_INFO`
`ORA-17090`	`operation not allowed`
`ORA-17012`	`Parameter Type Conflict`
`ORA-17030`	`READ_COMMITTED and SERIALIZABLE are the only valid transaction levels`
`ORA-17062`	`Ref cursor is invalid`
`ORA-17014`	`ResultSet.next was not called`
`ORA-17031`	`setAutoClose: Only support auto close mode on`
`ORA-17029`	`setReadOnly: Read-only connections not supported`
`ORA-17104`	`SQL statement to execute cannot be empty or null`
`ORA-17109`	`standard Java character encoding not found`
`ORA-17096`	`Statement Caching cannot be enabled for this logical connection`
`ORA-17095`	`Statement Caching is not enabled for this Connection object`
`ORA-17016`	`Statement timed out`
`ORA-17015`	`Statement was cancelled`
`ORA-17027`	`Stream has already been closed`
`ORA-17040`	`Sub Protocol must be specified in connection URL`
`ORA-17054`	`The LOB locator is not valid`
`ORA-17053`	`The size is not valid`
`ORA-17051`	`This API cannot be be used for non-UDT types`
`ORA-17052`	`This ref is not valid`
`ORA-17113`	`Thread interval value is more than the cache timeout value`
`ORA-17091`	`Unable to create resultset at the requested type and/or concurrency level`
`ORA-17086`	`Undefined column value on the insert row`
`ORA-17048`	`Undefined type`
`ORA-17005`	`Unsupported column type`
`ORA-17023`	`Unsupported feature`
`ORA-17088`	`Unsupported syntax for requested resultset type and concurrency level`
`ORA-17069`	`Use explicit XA call`
`ORA-17079`	`User credentials doesn't match the existing ones`
`ORA-17085`	`Value conflicts occurs`

HeteroRM XA Messages

The following are the JDBC error messages that are specific to the HeteroRM XA feature.

HeteroRM XA Messages Sorted by ORA Number

ORA Number	Message
`ORA-17200`	`Unable to properly convert XA open string from Java to C`
`ORA-17201`	`Unable to properly convert XA close string from Java to C`
`ORA-17202`	`Unable to properly convert RM name from Java to C`
`ORA-17203`	`Could not cast pointer type to jlong`
`ORA-17204`	`Input array too short to hold OCI handles`
`ORA-17205`	`Failed to obtain OCISvcCtx handle from C-XA using xaoSvcCtx`
`ORA-17206`	`Failed to obtain OCIEnv handle from C-XA using xaoEnv`
`ORA-17207`	`The tnsEntry property was not set in DataSource`
`ORA-17213`	`C-XA returned XAER_RMERR during xa_open`
`ORA-17215`	`C-XA returned XAER_INVAL during xa_open`
`ORA-17216`	`C-XA returned XAER_PROTO during xa_open`
`ORA-17233`	`C-XA returned XAER_RMERR during xa_close`
`ORA-17235`	`C-XA returned XAER_INVAL during xa_close`
`ORA-17236`	`C-XA returned XAER_PROTO during xa_close`

HeteroRM XA Messages Sorted Alphabetically

ORA Number	Message
`ORA-17203`	`Could not cast pointer type to jlong`
`ORA-17235`	`C-XA returned XAER_INVAL during xa_close`
`ORA-17215`	`C-XA returned XAER_INVAL during xa_open`
`ORA-17236`	`C-XA returned XAER_PROTO during xa_close`
`ORA-17216`	`C-XA returned XAER_PROTO during xa_open`
`ORA-17233`	`C-XA returned XAER_RMERR during xa_close`
`ORA-17213`	`C-XA returned XAER_RMERR during xa_open`
`ORA-17206`	`Failed to obtain OCIEnv handle from C-XA using xaoEnv`
`ORA-17205`	`Failed to obtain OCISvcCtx handle from C-XA using xaoSvcCtx`
`ORA-17204`	`Input array too short to hold OCI handles`
`ORA-17207`	`The tnsEntry property was not set in DataSource`
`ORA-17202`	`Unable to properly convert RM name from Java to C`
`ORA-17201`	`Unable to properly convert XA close string from Java to C`
`ORA-17200`	`Unable to properly convert XA open string from Java to C`

TTC Me ssages

This section lists TTC error messages, first sorted by ORA number, and then alphabetically.

TTC Messages Sorted by ORA Number

ORA Number	Message
`ORA-17401`	`Protocol violation`
`ORA-17402`	`Only one RPA message is expected`
`ORA-17403`	`Only one RXH message is expected`
`ORA-17404`	`Received more RXDs than expected`
`ORA-17405`	`UAC length is not zero`
`ORA-17406`	`Exceeding maximum buffer length`
`ORA-17407`	`invalid Type Representation(setRep)`
`ORA-17408`	`invalid Type Representation(getRep)`
`ORA-17409`	`invalid buffer length`
`ORA-17410`	`No more data to read from socket`
`ORA-17411`	`Data Type representations mismatch`
`ORA-17412`	`Bigger type length than Maximum`
`ORA-17413`	`Exceding key size`
`ORA-17414`	`Insufficient Buffer size to store Columns Names`
`ORA-17415`	`This type hasn't been handled`
`ORA-17416`	`FATAL`
`ORA-17417`	`NLS Problem, failed to decode column names`
`ORA-17418`	`Internal structure's field length error`
`ORA-17419`	`Invalid number of columns returned`
`ORA-17420`	`Oracle Version not defined`
`ORA-17421`	`Types or Connection not defined`
`ORA-17422`	`Invalid class in factory`
`ORA-17423`	`Using a PLSQL block without an IOV defined`
`ORA-17424`	`Attempting different marshaling operation`
`ORA-17425`	`Returning a stream in PLSQL block`
`ORA-17426`	`Both IN and OUT binds are NULL`
`ORA-17427`	`Using Uninitialized OAC`
`ORA-17428`	`Logon must be called after connect`
`ORA-17429`	`Must be at least connected to server`
`ORA-17430`	`Must be logged on to server`
`ORA-17431`	`SQL Statement to parse is null`
`ORA-17432`	`invalid options in all7`
`ORA-17433`	`invalid arguments in call`
`ORA-17434`	`not in streaming mode`
`ORA-17435`	`invalid number of in_out_binds in IOV`
`ORA-17436`	`invalid number of outbinds`
`ORA-17437`	`Error in PLSQL block IN/OUT argument(s)`
`ORA-17438`	`Internal - Unexpected value`
`ORA-17439`	`Invalid SQL type`
`ORA-17440`	`DBItem/DBType is null`
`ORA-17441`	`Oracle Version not supported. Minimum supported version is 7.2.3.`
`ORA-17442`	`Refcursor value is invalid`
`ORA-17443`	`Null user or password not supported in THIN driver`
`ORA-17444`	`TTC Protocol version received from server not supported`

TTC Messages Sorted Alphabetically

ORA Number	Message
`ORA-17424`	`Attempting different marshaling operation`
`ORA-17412`	`Bigger type length than Maximum`
`ORA-17426`	`Both IN and OUT binds are NULL`
`ORA-17411`	`Data Type representations mismatch`
`ORA-17440`	`DBItem/DBType is null`
`ORA-17437`	`Error in PLSQL block IN/OUT argument(s)`
`ORA-17413`	`Exceding key size`
`ORA-17406`	`Exceeding maximum buffer length`
`ORA-17416`	`FATAL`
`ORA-17414`	`Insufficient Buffer size to store Columns Names`
`ORA-17438`	`Internal - Unexpected value`
`ORA-17418`	`Internal structure's field length error`
`ORA-17433`	`invalid arguments in call`
`ORA-17409`	`invalid buffer length`
`ORA-17422`	`Invalid class in factory`
`ORA-17419`	`Invalid number of columns returned`
`ORA-17435`	`invalid number of in_out_binds in IOV`
`ORA-17436`	`invalid number of outbinds`
`ORA-17432`	`invalid options in all7`
`ORA-17439`	`Invalid SQL type`
`ORA-17408`	`invalid Type Representation(getRep)`
`ORA-17407`	`invalid Type Representation(setRep)`
`ORA-17428`	`Logon must be called after connect`
`ORA-17429`	`Must be at least connected to server`
`ORA-17430`	`Must be logged on to server`
`ORA-17417`	`NLS Problem, failed to decode column names`
`ORA-17410`	`No more data to read from socket`
`ORA-17434`	`not in streaming mode`
`ORA-17443`	`Null user or password not supported in THIN driver`
`ORA-17402`	`Only one RPA message is expected`
`ORA-17403`	`Only one RXH message is expected`
`ORA-17420`	`Oracle Version not defined`
`ORA-17441`	`Oracle Version not supported. Minimum supported version is 7.2.3.`
`ORA-17401`	`Protocol violation`
`ORA-17404`	`Received more RXDs than expected`
`ORA-17442`	`Refcursor value is invalid`
`ORA-17425`	`Returning a stream in PLSQL block`
`ORA-17431`	`SQL Statement to parse is null`
`ORA-17415`	`This type hasn't been handled`
`ORA-17444`	`TTC Protocol version received from server not supported`
`ORA-17421`	`Types or Connection not defined`
`ORA-17405`	`UAC length is not zero`
`ORA-17423`	`Using a PLSQL block without an IOV defined`
`ORA-17427`	`Using Uninitialized OAC`