Abnormal Errors after ORA-1013 received in Application (Doc ID 1073213.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version 10.2.0.1 to 11.2.0.3.0 [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***

Symptoms

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
or
ORA-1008: not all variables bounded
or
ORA-1006: bind variable does not exist
or
ORA-00600: internal error code, arguments: [12259], [], [], [], [], [], [], [], [], [], [], []
..

Changes

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

Cause

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