Error messages in Oracle mode|V2.4.14|OceanBase Connector/J |docs|OceanBase Documentations

This topic describes the error message structure and common error messages.

Error message structure

In the general error message structure, runtime information can be appended to the end of a message, following a colon, as follows:

<error_message>:<extra_info>

The following example shows a closed statement error message, indicating that an exception is thrown during a call to the next method of a result set object.

Closed Statement:next

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

Common error messages

The following table describes the error messages by ORA number.

ORA number	Error message	Description
ORA-17001	Internal Error	An internal error occurred.
ORA-17002	Io exception	An I/O exception is thrown.
ORA-17003	Invalid column index	The specified column index is invalid.
ORA-17004	Invalid column type	The specified column type is invalid.
ORA-17005	Unsupported column type	The column type is not supported.
ORA-17006	Invalid column name	The specified column name is invalid.
ORA-17007	Invalid dynamic column	The specified dynamic column is invalid.
ORA-17008	Closed Connection	The connection is closed.
ORA-17009	Closed Statement	The statement is closed.
ORA-17010	Closed Resultset	The result set is closed.
ORA-17011	Exhausted Resultset	The result set is exhausted.
ORA-17012	Parameter Type Conflict	A parameter type conflict occurs.
ORA-17014	ResultSet.next was not called	`ResultSet.next` is not called.
ORA-17015	Statement was cancelled	The statement is canceled.
ORA-17016	Statement timed out	The statement timed out.
ORA-17017	Cursor already initialized	The cursor is already initialized.
ORA-17018	Invalid cursor	The specified cursor is invalid.
ORA-17019	Can only describe a query	You can only describe a query.
ORA-17020	Invalid row prefetch	The row prefetch is invalid.
ORA-17021	Missing defines	The definition is missing.
ORA-17022	Missing defines at index	The definition is missing at the index.
ORA-17023	Unsupported feature	The feature is not supported.
ORA-17024	No data read	No data is read.
ORA-17025	Error in defines.isNull ()	An error occurred in `define.isNull()`.
ORA-17026	Numeric Overflow	A numeric overflow exception is thrown.
ORA-17027	Stream has already been closed	The stream is already closed.
ORA-17028	Can not do new defines until the current ResultSet is closed	You cannot declare new defines on a statement that has an open result set.
ORA-17029	setReadOnly: Read-only connections not supported	`setReadOnly`: Read-only connections are not supported.
ORA-17030	READ_COMMITTED and SERIALIZABLE are the only valid transaction levels	Only `READ_COMMITTED` and `SERIALIZABLE` are the valid transaction isolation levels.
ORA-17031	setAutoClose: Only support auto close mode on	`setAutoClose`: The auto close mode must be enabled.
ORA-17032	cannot set row prefetch to zero	You cannot set row prefetch to zero.
ORA-17033	Malformed SQL92 string at position	A malformed SQL92 string is found.
ORA-17034	Non supported SQL92 token at position	An unsupported SQL92 token is found.
ORA-17035	Character Set Not Supported !!	The specified character set is not supported.
ORA-17036	exception in OracleNumber	An exception in OracleNumber is thrown.
ORA-17037	Fail to convert between UTF8 and UCS2	Conversion between UTF8 and UCS2 is not supported.
ORA-17038	Byte array not long enough	The byte array is not long enough.
ORA-17039	Char array not long enough	The CHAR array is not long enough.
ORA-17040	Sub Protocol must be specified in connection URL	The subprotocol is required in the connection URL.
ORA-17041	Missing IN or OUT parameter at index:	The `IN` or `OUT` parameter is missing at the index.
ORA-17042	Invalid Batch Value	The specified batch value is invalid.
ORA-17043	Invalid stream maximum size	The specified maximum stream size is invalid.
ORA-17044	Internal error: Data array not allocated	Internal error: No data array is allocated.
ORA-17045	Internal error: Attempt to access bind values beyond the batch value	Internal error: An attempt was made to access bind values beyond the batch value.
ORA-17046	Internal error: Invalid index for data access	Internal error: The specified index for data access is invalid.
ORA-17047	Error in Type Descriptor parse	An error occurred while parsing the type descriptor.
ORA-17048	Undefined type	The type is undefined.
ORA-17049	Inconsistent java and sql object types	The Java and SQL object types are inconsistent.
ORA-17050	no such element in vector	No such element exists in the vector.
ORA-17051	This API cannot be used for non-UDT types	This API can be used only for user-defined types (UDTs).
ORA-17052	This ref is not valid	The specified `ref` is invalid.
ORA-17053	The size is not valid	The specified size is invalid.
ORA-17054	The LOB locator is not valid	The specified large object (LOB) locator is invalid.
ORA-17055	Invalid character encountered in	An invalid character is encountered.
ORA-17056	Non supported character set (add orai18n.jar in your classpath)	The character set is not supported. Make sure that `orai18n.jar` is added to the classpath.
ORA-17057	Closed LOB	The LOB is closed.
ORA-17058	Internal error: Invalid NLS Conversion ratio	Internal error: The specified National Language Support (NLS) conversion ratio is invalid.
ORA-17059	Fail to convert to internal representation	Unable to convert to internal representation.
ORA-17060	Fail to construct descriptor	Unable to construct the descriptor.
ORA-17061	Missing descriptor	The descriptor is missing.
ORA-17062	Ref cursor is invalid	The specified Ref cursor is invalid.
ORA-17063	Not in a transaction	Not in a transaction.
ORA-17064	Invalid Sytnax or Database name is null	The syntax is invalid or the database name is not specified.
ORA-17065	Conversion class is null	The conversion class is not specified.
ORA-17066	Access layer specific implementation needed	Access layer-specific implementation is required.
ORA-17067	Invalid Oracle URL specified	The specified URL is invalid.
ORA-17068	Invalid argument(s) in call	An invalid parameter is found in the call.
ORA-17069	Use explicit XA call	An explicit XA call must be used.
ORA-17070	Data size bigger than max size for this type	The data size exceeds the maximum size for this type.
ORA-17071	Exceeded maximum VARRAY limit	The `VARRAY` length exceeds the maximum limit.
ORA-17072	Inserted value too large for column	The value inserted is too large for the column.
ORA-17074	invalid name pattern	The specified name pattern is invalid.
ORA-17075	Invalid operation for forward only resultset	The operation is invalid for a forward-only result set.
ORA-17076	Invalid operation for read only resultset	The operation is invalid for a read-only result set.
ORA-17077	Fail to set REF value	Unable to set the REF value.
ORA-17078	Cannot do the operation as connections are already opened	Unable to perform the operation because connections are already opened.
ORA-17079	User credentials doesn't match the existing ones	User credentials do not match the existing ones.
ORA-17080	invalid batch command	The specified batch command is invalid.
ORA-17081	error occurred during batching	An error occurred during batching.
ORA-17082	No current row	The current row is not found.
ORA-17083	Not on the insert row	The cursor is not positioned on the insert row.
ORA-17084	Called on the insert row	The cursor is positioned on the insert row.
ORA-17085	Value conflicts occurs	A value conflict exception is thrown.
ORA-17086	Undefined column value on the insert row	No column values have been set on the row to be inserted.
ORA-17087	Ignored performance hint: setFetchDirection()	Ignorable performance hint: `setFetchDirection()`.
ORA-17088	Unsupported syntax for requested resultset type and concurrency level	The syntax for the requested result set type and concurrency level is not supported.
ORA-17089	internal error	An internal error occurred.
ORA-17090	operation not allowed	The operation is not allowed.
ORA-17091	Unable to create resultset at the requested type and/or concurrency level	Unable to create a result set of the requested type and/or at the requested concurrency level.
ORA-17092	JDBC statements cannot be created or executed at end of call processing	Unable to create or execute JDBC statements at the end of call processing.
ORA-17094	Object type version mismatched	The object type and version do not match.
ORA-17095	Statement cache size has not been set	The statement cache size is not specified.
ORA-17096	Statement Caching cannot be enabled for this logical connection.	Unable to enable statement caching for this logical connection.
ORA-17097	Invalid PL/SQL Index Table element type	The element type of the PL index table is invalid.
ORA-17098	Invalid empty lob operation	Operations on an empty LOB are invalid.
ORA-17099	Invalid PL Index Table array length	The specified array length of the PL index table is invalid.
ORA-17100	Invalid database Java Object	The specified database Java object is invalid.
ORA-17103	invalid connection type to return via getConnection. Use getJavaSqlConnection instead	The connection type returned by `getConnection` is invalid. Use `getJavaSqlConnection` instead.
ORA-17104	SQL statement to execute cannot be empty or null	The SQL statement to be executed cannot be empty or null.
ORA-17105	connection session time zone was not set	The session time zone is not set for the connection.
ORA-17107	invalid proxy type specified	The specified proxy type is invalid.
ORA-17108	No max length specified in defineColumnType	The maximum length is not specified in `defineColumnType`.
ORA-17109	standard Java character encoding not found	The standard Java character encoding is not found.
ORA-17110	execution completed with warning	The statement has been executed with a warning.
ORA-17111	Invalid connection cache TTL timeout specified	The specified connection cache TTL is invalid.
ORA-17112	Invalid thread interval specified	The specified thread interval is invalid.
ORA-17113	Thread interval value is more than the cache timeout value	The thread interval is longer than the cache timeout period.
ORA-17114	could not use local transaction commit in a global transaction	Local transaction commits cannot be used in a global transaction.
ORA-17115	could not use local transaction rollback in a global transaction	Local transaction rollback cannot be used in a global transaction.
ORA-17116	could not turn on auto-commit in an active global transaction	Auto-commit cannot be used in an active global transaction.
ORA-17117	could not set savepoint in an active global transaction	Savepoints cannot be set in an active global transaction.
ORA-17118	could not obtain ID for a named Savepoint	The ID of a named savepoint cannot be obtained.
ORA-17119	could not obtain name for an un-named Savepoint	The name of an unnamed savepoint cannot be obtained.
ORA-17120	could not set a Savepoint with auto-commit on	Unable to set a savepoint with auto-commit enabled.
ORA-17121	could not rollback to a Savepoint with auto-commit on	Unable to roll back to a savepoint with auto-commit enabled.
ORA-17122	could not rollback to a local txn Savepoint in a global transaction	Unable to roll back to a local transaction savepoint in a global transaction.
ORA-17123	Invalid statement cache size specified	The specified statement cache size is invalid.
ORA-17124	Invalid connection cache Inactivity timeout specified	The deactivation timeout period specified for the connection cache is invalid.
ORA-17125	Improper statement type returned by explicit cache	The explicit cache returned an invalid statement type.
ORA-17126	Fixed Wait timeout elapsed	The fixed wait timeout period has elapsed.
ORA-17127	Invalid Fixed Wait timeout specified	The fixed wait timeout period specified is invalid.
ORA-17128	SQL string is not Query	The SQL string is not a query.
ORA-17129	SQL string is not a DML Statement	The SQL string is not a DML statement.
ORA-17132	Invalid conversion requested	The requested conversion is invalid.
ORA-17133	UNUSED	`UNUSED`.
ORA-17134	Length of named parameter in SQL exceeded 32 characters	The length of named parameters in the SQL statement exceeds 32 characters.
ORA-17135	Parameter name used in setXXXStream appears more than once in SQL	The parameter name used in `setXXXStream` has appeared more than once in the SQL statement.
ORA-17136	Malformed DATALINK URL, try getString() instead	The format of the DATALINK URL is invalid. Try using `getString()`.
ORA-17137	Connection Caching Not Enabled or Not a Valid Cache Enabled DataSource	Connection caching is not enabled, or the data source is not a valid cache-enabled data source.
ORA-17138	Invalid Connection Cache Name. Must be a valid String and Unique	The name of the connection cache is invalid. The name must be a valid string and unique.
ORA-17139	Invalid Connection Cache Properties	The properties of the connection cache are invalid.
ORA-17140	Connection Cache with this Cache Name already exists	A connection cache with this name already exists.
ORA-17141	Connection Cache with this Cache Name does not exist	The connection cache with this name does not exist.
ORA-17142	Connection Cache with this Cache Name is Disabled	The connection cache with this name is disabled.
ORA-17143	Invalid or Stale Connection found in the Connection Cache	The connection found in the connection cache is invalid or has expired.
ORA-17144	statement handle not executed	The statement handle is not executed.
ORA-17145	Invalid ONS Event received	The ONS event received is invalid.
ORA-17146	Invalid ONS Event Version received	The version of the ONS event received is invalid.
ORA-17147	Attempt to set a parameter name that does not occur in the SQL	An attempt was made to set a named parameter that does not exist.
ORA-17149	This is already a proxy session	This is already a proxy session.
ORA-17150	Wrong arguments for proxy session	The proxy session contains invalid arguments.
ORA-17151	Clob is too large to be stored in a Java String	The CLOB is too large to be stored in a Java string.
ORA-17152	This method is only implemented in logical connections	This method is implemented only in logical connections.
ORA-17153	This method is only implemented in physical connections	This method is implemented only in physical connections.
ORA-17156	Invalid array size for End-to-End metrics values	The array size is invalid for end-to-end metrics.
ORA-17157	setString can only process strings of less than 32766 chararacters	`setString` can process only strings containing less than 32,766 characters.
ORA-17158	duration is invalid for this function	Duration is invalid for the function.
ORA-17159	metric value for end-to-end tracing is too long	The metric value for executing end-to-end tracing is too long.
ORA-17160	execution context id sequence number out of range	The sequence number of the execution context ID is out of range.
ORA-17161	Invalid transaction mode used	The transaction mode used is invalid.
ORA-17162	Unsupported holdability value	The specified `holdability` value is not supported.
ORA-17163	Can not use getXAConnection() when connection caching is enabled	You cannot use `getXAConnection()` when connection caching is enabled.
ORA-17164	Can not call getXAResource() from physical connection with caching on	You cannot call `getXAResource()` from a physical connection that has connection caching enabled.
ORA-17165	DBMS_JDBC package not preset in server for this connection	The `DBMS_JDBC` package for the connection does not exist on the server.
ORA-17166	Cannot perform fetch on a PL statement	You cannot perform fetch on a PL statement.
ORA-17167	PKI classes not found. To use 'connect /' functionality, oraclepki.jar must be in the classpath	The required Public Key Infrastructure (PKI) classes cannot be found. To use the `connect/` feature, `oraclepki.jar` must be in the classpath.
ORA-17168	encountered a problem with the Secret Store. Check the wallet location for the presence of an open wallet (cwallet.sso) and ensure that this wallet contains the correct credentials using the mkstore utility	An issue related to credential storage occurred. When you open the wallet (`cwallet.sso`), check the location of the wallet and use the `mkstore` utility to ensure that this wallet contains the correct identity credentials.
ORA-17169	Cannot bind stream to a ScrollableResultSet or UpdatableResultSet	You cannot bind a stream to `ScrollableResultSet` or `UpdatableResultSet`.
ORA-17170	The Namespace cannot be empty	The namespace cannot be empty.
ORA-17171	The attribute length cannot exceed 30 chars	The attribute length cannot exceed 30 characters.
ORA-17172	That value of the attribute cannot exceed 400 chars	The attribute value cannot exceed 400 characters.
ORA-17173	Not all return parameters registered	One or more return parameters have not been registered.
ORA-17174	The only supported namespace is CLIENTCONTEXT	The only supported namespace is `CLIENTCONTEXT`.
ORA-17175	Error during remote ONS configuration	An error occurred during remote ONS configuration.
ORA-17259	SQLXML cannot find the XML support jar file in the classpath	SQLXML cannot find the XML support JAR file in the classpath.
ORA-17260	Attempt to read an empty SQLXML	An attempt was made to read an empty SQLXML.
ORA-17261	Attempt to read a SQLXML that is not readable	An attempt was made to read a SQLXML that is not readable.
ORA-17262	Attempt to write a SQLXML that is not writeable	An attempt was made to write a SQLXML that is not writable.
ORA-17263	SQLXML cannot create a Result of that type	SQLXML cannot create a result of this type.
ORA_17264	SQLXML cannoct create a Source of that type	SQLXML cannot create a source of this type.