Oracle Forms (MOSC)

MOSC Banner

Commit not commiting to the database tilll we exit the form

edited Oct 27, 2010 7:49PM in Oracle Forms (MOSC) 5 commentsAnswered
Hi,

We are using Forms 6i.

I have been developing Forms since 10 yrs but never had this problem. 

I have a form in which I have added a button to update a table.The code for the WHEN BUTTON PRESSED trigger is updating the table and doing a COMMIT.

When the user presses the button, I can see there is a lock on the table being updated. But the data is not updated in the database yet.

So I put the code on another button which has COMMIT and EXIT_FORM. When I press this button the data is commited.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center