Re: ORA-01747 error using Table Data Editor

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 03 Dec 2002 12:00:14 +0200
Message-ID: <ashvev$j02$2@ctb-nnrp2.saix.net>

Scott Hamlin wrote:

> 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.

<snipped>

As Sybrand said, the actual SQL will help a lot Scott.

> Any ideas?

Well, the database table and columns could be case sensitive. Or the table editor app could be making the column names case sensitive by applying double quotes indiscriminately.

--
Billy

Received on Tue Dec 03 2002 - 04:00:14 CST