Abnormal Errors after ORA-1013 received in Application

(Doc ID 1073213.1)

Last updated on DECEMBER 01, 2017

Applies to:

JDBC - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Aug-2013***
***Checked for relevance on 11-Feb-2016***


setQueryTimeout is being used to cancel long running Statements, also Statement Caching is enabled.

A Query timeout results in the following Exception:
"ORA-01013: user requested cancel of current operation"

After this error, the Application sometimes gets abnormal errors when trying to execute a new (reused) PreparedStatement:
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-1008: not all variables bounded
ORA-1006: bind variable does not exist
ORA-00600: internal error code, arguments: [12259], [], [], [], [], [], [], [], [], [], [], []


possible changes:
- activation of Statement Caching
- activation of setQueryTimeout
- maybe higher load or longer running queries resulting in QueryTimeout being hit


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms