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.