oracle forms FRM-40401 error raises when "execute_query" issued after "commit"

Question

I have form that has button when clicked a smart trigger will be executed updating some columns but when I try to use after commit the following statement:

execute_query;

i get

FRM-40401 : no changes to save

how to solve this?

Answer 1

EXECUTE_QUERY can't raise that message; it is COMMIT that does that.

If you need it (because you have to save changes you've made), then a simple option is to "mask" it, e.g.

:system.message_level := 25;
commit;
:system.message_level := 0;

In other words: set a message level to a high level so that the message you got isn't displayed (as its message level is lower than 25). After commit, restore the system message level to its default value (which is 0, meaning "display all messages").