Learn how to a build a cloud-first strategyRegister Now


FRM-40401 Error, but there ARE changes.

Posted on 2012-08-23
Medium Priority
Last Modified: 2012-08-29
I keep getting a FRM-40401 error in Oracle Forms 10g even though a field HAS changed. I am updating with FORMS, not writing my own updates.

The block is table based. What would cause this error (message) to appear when there ARE changes?

Question by:errodr34
  • 2
LVL 21

Expert Comment

ID: 38327071
what forms version are you using

No POST build-in  executed in a trigger before the COMMIT_FORM or twice a COMMIT_FORM  ?
What is the user action that triggers the message  ?
The changed field is a datebase item ?

Accepted Solution

errodr34 earned 0 total points
ID: 38329581
The problem was that DML Data Target Type and DML Data Target Name were null.

Author Closing Comment

ID: 38344681
Found this solution as I ran debug on the form.

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month20 days, 16 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question