Abnormal Errors after ORA-1013 received in Application
(Doc ID 1073213.1)
Last updated on FEBRUARY 28, 2023
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.
*** ***
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |