From: keithdmiller@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: "views" as a column name
Date: Tue, 10 Oct 2000 16:03:09 GMT
Organization: Deja.com - Before you buy.
Lines: 45
Message-ID: <8rvejm$8v6$1@nnrp1.deja.com>
NNTP-Posting-Host: 206.243.194.70
X-Article-Creation-Date: Tue Oct 10 16:03:09 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.1 x58.deja.com:80 (Squid/1.1.22) for client 206.243.194.70
X-MyDeja-Info: XMYDJUIDkeithdmiller


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.