Re: Reserved word? or not?

Keyword LANGUAGE is used in pl/sql when creating external procedures. http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_extern_proc.htm#i1006405 It is also pl/sql keyword
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/reservewords.htm#CIHFDHGB

The syntax was the same also in 9i, don't know why it throws error now. Probably more strict restrictions on using them.

Gints Plivna
http://www.gplivna.eu

2008/9/24 Jack van Zanen <jack_at_vanzanen.com>:
> Hi All
>
> We have an external table that reads from a datafile just fine in Oracle 9i.
> However we upgraded our test environment to 10G and now it complaints about
> the column name "LANGUAGE". It expects double quotes.
>
> I had a look in the v$reserved_words view and do not see this word as
> reserved.
> Changing the column name to language1(or something) fixes the problem, but
> I am wondering why we need to do this.
>
>
> Brgds
>
> --
> J.A. van Zanen
>

--
http://www.freelists.org/webpage/oracle-l