Hi:

Is there any way to lock a table past the commit point?. I want to lock a table run some DMLs (say delete) and release the table, when done. I do not want to release the lock when issuing a commit, because after commiting and bofore re-acquiring the lock, somebody else could lock/use the table.

I want the table to be locked for the entire duration of the application.

I am running Ora 8.1.6

Thanks