I am trying to insert a row into a table and I am receiving an error:
ORA-01747 invalid user.table.column, table.column, or column specification.
I am using the table data editor to do so, and trying to insert only two
fields, the only two required fields. One is called ID, the other is called
NAME. The table name is ADDRESS. There is one field with a foreign key
restraint, STATE_FK, but that field allows nulls. I have filled it in with a
valid value just in case, but the same message occurs. I have seen other
messages regarding this error, but they are for SQL errors, not using the
table data editor. Any ideas?
Thank you,
Scott
Received on Mon Dec 02 2002 - 13:12:45 CST
