Hello,
we are migrating our forms from 11g to 12c and we are having some issue with saving data.
Some problem has been resolved after changing commit; to commit_form;.
Recently we found the following pl/sql script working differently from 11g to 12c and it give us problem.
The modulo has some block base table where we add and remove record using only post; command.
When we don't want to save the change we made we call the following command.
Clear_Form (no_validate);
DELETE FROM TABLE;
commit;
In forms 11g it discharge all the data and save ONLY the delete while in the 12C it save all.
At the moment we add a rollback after the Clear_form and it seems to work.
But we have many module Clear_Form(NO_Validate); and don't want to add a rollback after each clear_form.
Is it a bug or is it a change in behaviour?
Thank you for your help.
Saluti.