Q
Problem solve Get help with specific problems with your technologies, process and projects.

FRM-40401: no change to save

I am entering the following code from Developer but it gives an error, "FRM-40401: no change to save."

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.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

I passed this error recently.
To circumvent this problem, in the module property <> keep the value <>.
Hope that helps.

--
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close