Press "Enter" to skip to content

FRM-40102: Record must be entered or deleted first – Tips

The FRM-40102: Record must be entered or deleted first happen when you try to edit a record and leave blank a required field and without saving it or deleting it, you try to move on to next record or database block. Better you first cancel the operation if you dont want to complete the transaction.

Oracle Form’s error information

Cause: You pressed [Next Record] or [Down] in a context where it is meaningless. Either:

1. The last record in a block is the current record.

2. The block is empty.

3. You are in a new record in the middle of the block created by pressing [Insert Record].

Action: No action is necessary.
Level: 5

Trigger: ON-ERROR

Vinish Kapoor

I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me, it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub and get notifications for new posts.

You may also like:

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *