Last updated on AUGUST 03, 2016
Applies to:JDBC - Version 10.2.0.1 to 220.127.116.11.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***
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms