CODEWITHSUNDEEP
c#oracle11g
Anand Kumar
Anand Kumar

Reputation: 425

ORA-01013: user requested cancel of current operation

When I execute a delete storedprocedure I am getting "ORA-01013: user requested cancel of current operation".

And also it takes time (about more than 10 seconds) to throw exception from the application

when I execute this query in Toad it takes more than 30 seconds, when i cancel it, in the output windows, it shows above error.

I think, dataaccess blog is cancels automatically when it exeeds the timeout.

I am wondering why it takes 30 seconds. And when I run the select query alone, there are no records.

When I call delete only it takes time.

DELETE FROM ( SELECT *
       FROM VoyageVesselBunkers a
       JOIN VoyageVessel b
       ON  a.VoyageVesselId = b.Id
       WHERE a.Id    = NVL(null,a.Id)
       AND  b.VoyageId   = NVL('5dd6a8fbb69d4969b27d01e6c6245094',b.VoyageId)
       AND  a.VoyageVesselId = NVL(null,a.VoyageVesselId) );

any suggestion. anand

Upvotes: 3

Views: 40516

Answers (3)

jdnew18
jdnew18

Reputation: 165

If you have uncommitted changes to a data row sitting in a SQL editor (such as SQL Developer, Oracle, etc.), and you try to update the same row via another program (perhaps one that is running in an IDE such as Visual Studio), you will also get this error. To remedy this possible symptom, simply commit the change in the SQL editor.

Upvotes: 6

Justin Cave
Justin Cave

Reputation: 231781

Your code is setting a timeout (storedProcCommand.CommandTimeout). The error indicates that the stored procedure call is taking longer than the allowed timeout will allow so it is cancelled. You would either need to increase (or remove) the timeout or you would need to address whatever performance issue is causing the procedure call to exceed the allowed timeout.

Upvotes: 3

forrest
forrest

Reputation: 9

ORA-01013 user requested cancel of current operation

Cause: The user interrupted an Oracle operation by entering CTRL-C, Control-C, or another
canceling operation. This forces the current operation to end. This is an informational
message only.

Action: Continue with the next operation.

Upvotes: -4

Related Questions