title: ORA-01013: user requested cancel of current operation
body: <p>When I execute a delete storedprocedure I am getting "ORA-01013: user requested cancel of current operation".</p>
  
  <p>And also it takes time (about more than 10 seconds) to throw exception from the application </p>
  
  <p>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.</p>
  
  <p>I think, dataaccess blog is cancels automatically when it exeeds the timeout.</p>
  
  <p>I am wondering why it takes 30 seconds. And when I run the select query alone, there are no records. </p>
  
  <p>When I call delete only it takes time.</p>
  
  <pre><code>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) );
  </code></pre>
  
  <p>any suggestion.
  anand</p>