Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01747 error using Table Data Editor
This is because the column you have called 'NAME' is an Oracle keyword. You should change it to FULLNAME or something else other than a keyword. I've been having similar problems with columns named OPTION and DESC, i've had to change these.
There's 660 reserved words in oracle (my version of 8i at least) of things not to call your columns.. these are obtained by doing a select:
"select keyword from V$reserved_words"
Hope this helps solve your problem.
-- Posted via http://dbforums.comReceived on Thu May 22 2003 - 05:02:41 CDT