I am entering the following code from Developer but it gives an error, "FRM-40401: no change to save."
forms_ddl('update fiu_owner_info_temp set COUNTRY_CODE_RES1='||'BDD'); commit_form;
The error message is correct. When you perform DML on a field that is not on your form, this is considered a database change, not a form change. Since nothing on the form or on the block has changed, there is nothing to save. You do need a commit command to save your database change. I suggest the following sequences of commands:
:System.Message_Level := '20'; commit; :System.Message_Level := '0';
By assigning '20' to :system.message_level, only the most severe error message will be displayed. All other error messages will be suppressed, including the "no changes to save" error message. When assigning '0' to :system.message_level, this allows all error messages to be displayed.
Dig Deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.