As I understand the ENQUE_<object> will lock the object only for till the transaction/program terminates. Is there a way to get a lock beyond this?
My requirement is in Workflow, where I need to lock an object till an approval happens. This approval process might take days to happen, and the object should be locked till then. I experimented with the _SCOPE parameter and it did not help. Any ideas?