From: "Jim Gregory" <JG200024@NCR.com>
Newsgroups: comp.databases.oracle.misc
References: <8rvejm$8v6$1@nnrp1.deja.com>
Subject: Re: "views" as a column name
Date: Tue, 10 Oct 2000 13:37:15 -0400
Lines: 57
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Original-NNTP-Posting-Host: wusjg200024.daytonoh.ncr.com
Message-ID: <39e353cb$1@rpc1284.daytonoh.ncr.com>
X-Original-Trace: 10 Oct 2000 13:37:15 -0400, wusjg200024.daytonoh.ncr.com
NNTP-Posting-Host: ncrnews.daytonoh.ncr.com
X-Trace: 10 Oct 2000 13:37:18 -0400, ncrnews.daytonoh.ncr.com


Have you tried enclosing it in double quotes ( "views" )?

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
<keithdmiller@my-deja.com> wrote in message
news:8rvejm$8v6$1@nnrp1.deja.com...
> I have inherited a table which has a column named "views"
> an example is below
>
> create table test_views
> (
>    views number
> )
> ;
> insert into test_views values (1)
> ;
> update test_views
> set views = 3
> ;
>
> The above three statements result in a value of 3 in this field
>
>
> if I execute these statements within a pl/sql block
>
> begin
> insert into test_views values (1) ;
> update test_views
> set views = 3;
> end;
>
>
> I get the following error:
> ORA-06550: line 6, column 5:
> PLS-00103: Encountered the symbol "VIEWS" when expecting one of the
> following:
>
>    ( <an identifier> <a double-quoted delimited-identifier>
> The symbol "<an identifier> was inserted before "VIEWS" to continue.
>
> Currently a c++ program thru ADO is updating this field but I need to
> do it in an PL/SQL procedure.
>
> Is there any way to positionally bind this column or escape the
> reserved word?
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.