Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

reserved words

638484May 9 2008 — edited May 12 2008
I have a table with a column name = 'value'

(legacy DB so have I no control over column names)

Am writing a PL/SQL script to insert some rows & am falling foul of the fact that value is a reserved word in PL/SQL

I get a PL/SQL: ORA-00904: "VALUE": invalid identifier error msg

any ideas how/if I can workaround this
Or have I got to re-implement my script as a piece of code in (say) Java or something else
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2008
Added on May 9 2008
15 comments
1,134 views