FRM-40508 : ORACLE error: unable to INSERT record tips
Oracle Error Tips by Stephanie Filio of Burleson Consulting
Oracle notes these details on the
FRM-40508 : ORACLE error: unable to INSERT record.
Cause: A fatal error
occurred while Oracle Forms was trying to insert
a record. The table associated with the current block of the form
might not exist, your username might not have authority to
perform the specified action on the table, or some other reason
might have caused the fatal error.
Action: Contact your DBA.
has published some great information regarding FRM-40508,
which may help to remedy the FRM-40508 error:
Use the Display Error
Key or Menu Option.
The Display Error key or menu option will invoke a dialog window that will
contain the SQL INSERT statement that Forms was trying to execute when the
FRM-40508 error occurred, and the actual ORACLE error that occurred.
INSERT statement is too long to determine where the error occurred, turn OFF
the Base Table property of some non-required items in the block to shorten
the INSERT statement.
Keep in mind that if you change the database table
structure, you have to remember to make reflective changes to the Forms base
To invoke the Display Error:
1. Display Error is
available from the HELP menu using the Forms Default
2. A [Display Error] key is available. Use SHOW KEYS to determine what
device-specific key is mapped to the Display Error functionality for
3. The Display Error functionality can be invoked programmatically using the
DISPLAY_ERROR Forms built-in.