Re: Reserved word? or not?

  • From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • To: jack@xxxxxxxxxxxx
  • Date: Wed, 24 Sep 2008 11:02:20 +0300

Keyword LANGUAGE is used in pl/sql when creating external procedures.
It is also pl/sql keyword

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

2008/9/24 Jack van Zanen <jack@xxxxxxxxxxxx>:
> 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

Other related posts: