Re: ORA-01747 error using Table Data Editor

"Scott Hamlin" <HamlinS_at_smu.edu> wrote in message news:asgb9r$r2q6a$1_at_ID-147295.news.dfncis.de...
> 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
>
>

Please post the statement resulting from pressing the 'SHOW SQL' button. Crystall balls have sold out here.

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address