Clear_Form / Clear_Block built-ins and Rollbacks
502956Apr 11 2006 — edited Apr 12 2006First off, I want to make sure I have this right. Both Clear_Form and Clear_Block with a NO_COMMIT or NO_VALIDATE passed will execute a database ROLLBACK correct?
I am assuming that this is the case as some of my non-committed transactions are being rolled back after a clear_form call. Here is my situation:
The users will enter any number of related transactions. This meaning, either all of them commit or all of them rollback. My problem is that each time a transaction is completed, the Form needs to clear so they can begin the next transaction. Being that this is a big form, it is much easier to use the Clear_Form tool to clear everything. However, I do not want the prior transaction to rollback.
Is there another way to clear a form without issuing a rollback? The form is too big to manually clear out each data block. Should I try using savepoints (I have many clear_block calls however)? I have also tinkered with the idea of using library package pl/sql table variables to store the prior transactions, and do one final insert at the end.
Thoughts anyone? Thanks!
Mike