ORA-01747: invalid user.table.column, table.column, or columns specification
Cause: You tried to reference a column name, but the column name used is a reserved word in Oracle.
Action:
The options to resolve this Oracle error are:
Try redefining your table so that none of your column names are reserved words.
Try enclosing the reserved word in double quotes.
For example, if you had a supplier table with a column named number, and you
tried to update this field as follows:
UPDATE suppliers
SET number = 10000;
You would receive the following error message.
You could correct this error by enclosing the column name in double quotes as follows:
UPDATE suppliers
SET "number" = 10000;
All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors
Thursday, December 27, 2007
ORA-01747
Posted by Admin at 12/27/2007 01:45:00 PM
Labels: Oracle, Oracle Error
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment