I know there are two modes in oracle:
automatic and manual; for manual I mastery but the alternative ideas I just on consultation (using execute_query) but for the update I have not ideas ...
for the button, it is that there must be a trigger (when-button-pressed)? If yes, what it will contain code in pl / sql?
You didn't solve the problem, you simply bypassed it. But be aware that standard.commit will NOT save ANY oustanding changes in your forms-blocks, it will only commit things which you inserted, updated or deleted by your own DML-statements.