Abnormal Errors after ORA-1013 received in Application
(Doc ID 1073213.1)
Last updated on FEBRUARY 14, 2022
Applies to:JDBC - Version 10.2.0.1 to 18.104.22.168.0 [Release 10.2 to 11.2]
Information in this document applies to any platform.
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: , , , , , , , , , , , 
- activation of Statement Caching
- activation of setQueryTimeout
- maybe higher load or longer running queries resulting in QueryTimeout being hit
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