Skip to Main Content

Oracle Forms

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!

Clear_Form / Clear_Block built-ins and Rollbacks

502956Apr 11 2006 — edited Apr 12 2006
First 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2006
Added on Apr 11 2006
6 comments
10,179 views