How to avoid Oracle Form to perform commit action ?
I have a question. The case is: After a user correct some data displayed in text items, he needs to click a button to update the record. However, the oracle form the commit the update action. I don't want to allow Oracle Form to perform commit UNTIL the user closes the oracle form. Is it possible to do so? If yes, I should use what kinds of Trigger to realize this. Thanks a lot.

Software/Hardware used:
oracle form
ASKED: November 5, 2011  1:52 PM
UPDATED: November 7, 2011  4:04 PM

Answer Wiki:
I'm not sure why you would want to do that. If you don't commit the update, no other user will be able to see the changes until the form is committed, so I don't see the need to update the database beforehand. In any case, if you want to do it, theoretically (I have never tested it) the POST built-in procedure should allow you to do that. Look for it in the Form Builder help.
Last Wiki Answer Submitted:  November 7, 2011  4:04 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _