Oracle Forms (MOSC)

MOSC Banner

post-insert change to database block item not committing.

edited Apr 2, 2019 5:05AM in Oracle Forms (MOSC) 3 commentsAnswered ✓

I am attempting to change a header block item to another value once a commit_form call is made.

I have created a timer that calls the commit_form, and all changes made.

I have created a post-insert, and post-update trigger to update the header block's item(database item) and set it like this.

: block.item := 'value';

I turned off all my on-error messages to make sure there wasn't a blocked error, and it told me, when I attempted to save again, 'No changes to save'(which I previously removed this message for ease of usage).

My 'detail' block's data 'does' get committed.

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