1

Perhaps, this is a naive question. When we use SQLDeveloper to execute a big query to Oracle, the we cancel the task. I wonder if it helps to cancel the execution of the server or not?

Thanks,

Loc Phan
  • 4,304
  • 4
  • 29
  • 35

1 Answers1

2

yes, in case the DB server finds the time to handle the protocol message, it cancels the execution of the statement and returns an ORA-01013: user requested cancel of current operation instead of an SQL result set.

BertNase
  • 2,374
  • 20
  • 24
  • Thanks BertNase. Do you have any reference for this? – Loc Phan Apr 21 '11 at 07:59
  • http://www.dba-oracle.com/t_ora_01013_user_requested_cancel_of_current_operation.htm – BertNase Apr 21 '11 at 10:18
  • Exactly the same thing done programmatically in own code seems to be discussed in this Question: http://stackoverflow.com/q/656162/702599 – BertNase Apr 21 '11 at 10:26
  • I am not sure because I haven't tested it and there is no explicit document of SQLDeveloper saying that. Of course, it is nearly 99% that the answer is correct. – Loc Phan May 23 '11 at 03:56