Error: ORA-00904: invalid column name.

Message

ORA-00904: invalid column name

Cause of Error

This behavior occurs because one or more of the column names that you specify in the SQL INSERT statement are incorrect.

Solution Summary

Determine the correct column names with the DESCRIBE command, and then use the correct column names in the SQL statement.

Solution Details

1) If you are not sure about what the correct column names are, type the following command at the SQL*Plus prompt, and then press ENTER to list all the names of the columns in the underlying table:
DESCRIBE .
where is the user name of the table owner and

is the name of the table where you are trying to insert data.
2) Make necessary changes to your SQL statement, based on the names that are displayed.
3) Execute the revised SQL statement.

Applies to Software Version

Oracle8