Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I stop (Kill) an Stored Procedure?

583252Jun 14 2007 — edited Jun 15 2007
Hi All,

I have several Stored Procedures to extract data from a database to anothe database the SP's takes approximately 3 hours, they are calls from java.

Can I stop the SP from java code and rollback all the actions from him????
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2007
Added on Jun 14 2007
4 comments
2,365 views