Re: Insert command

From: ddf <>
Date: Fri, 19 Aug 2011 13:50:48 -0700 (PDT)
Message-ID: <>

On Aug 19, 9:27 am, Tim Slattery <> wrote:
> Robert Klemme <> wrote:
> >Did you remove the at signs in the Oracle version of the SP?
> Yes, they're gone, I don't know why I put them in the original post.
> The "ORA-00936: Missing Expression" appears whether or not the column
> list is in the insert statement.
> Three of the columns are named "name", "category", and "native". SQL
> Developer shows these in bold face when I include the column list in
> the insert statement. I don't think it has anything to do with the
> error, but what's up with that? They're not reserved words, I looked
> up a list of Oracle reserved words and none of them are on it.
> --
> Tim Slattery
> Slatter..._at_bls.gov

Where did you find this list? In 10g both 'NATIVE' and 'CATEGORY' are found in v$reserved_words, indicating that Oracle considers them as such.

David Fitzjarrell Received on Fri Aug 19 2011 - 15:50:48 CDT

Original text of this message