CODEWITHSUNDEEP
javaoracle-database
varun
varun

Reputation: 726

How to cancel call to oracle stored procedure?

I have a java application, which searches for some records in oracle on click of search button. It calls stored procedures to search the data in oracle tables. Sometimes the search output is very large and takes a lot of time to process, I want to implement a cancel button so that the operation can be cancelled at any time. I thought of implementing separate thread in java but it wont solve the problem because the stored procedure is already called. How can i achieve this?

Upvotes: 0

Views: 1289

Answers (1)

commit
commit

Reputation: 4807

You should create another stored procedure which contains kill command to cancel running store procedure and call this new SP from your cancel button.

For killing running SP refer this:

How to terminate Oracle procedures which is running

Upvotes: 3

Related Questions