Re: Insert command

From: ddf <oratune_at_msn.com>
Date: Fri, 19 Aug 2011 13:50:48 -0700 (PDT)
Message-ID: <9870cbbb-45f6-48a3-8af0-092b393e8dec_at_v2g2000vba.googlegroups.com>

On Aug 19, 9:27 am, Tim Slattery <Slatter..._at_bls.gov> wrote:
> Robert Klemme <shortcut..._at_googlemail.com> 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.govhttp://members.cox.net/slatteryt

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