FRM-40401 Error, but there ARE changes.

Posted on 2012-08-23
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
    LVL 20

    Expert Comment

    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

    The problem was that DML Data Target Type and DML Data Target Name were null.

    Author Closing Comment

    Found this solution as I ran debug on the form.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now