Error: FRM-40508: ORACLE error: unable to INSERT record (due to absent table).

Message

FRM-40508: ORACLE error: unable to INSERT record.

Cause of Error

This behavior occurs because the table where you tried to insert records does not exist in the database.

Solution Summary

Create the necessary table, and then run the form again to insert the record.

Solution Details

NOTE: To be able to create a table, you must have sufficient account privileges to access the appropriate database and to create new tables in the database.

1) If you have not already done so, start SQL*Plus 8.0, and then log on to the appropriate database.
2) At the SQL*Plus prompt, type the following command, and then press ENTER:
CREATE TABLE (
,
,
);
where

is the name of the table you want to create, through are the names of the columns you want to create in the table, and is the datatype for a specific column.

NOTE 1: Make sure to end the command with a semicolon (;).

NOTE 2: For some datatypes, such as CHAR, VARCHAR2, or NUMBER, you need to specify the width or precision of values. Also, you can add constraints for the table or for a specific column. For example, you can specify the primary key for the table; you can also specify the NOT NULL constraint for a column, which means that you must enter a value for that column when you add a row to the table.
3) Run the form again to insert the record.

Applies to Software Version

Oracle8