Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: "views" as a column name
Or precede the columnname with the tablename
set test_views.views=3;
Arie Mars
arie_at_pca-online.nl
<keithdmiller_at_my-deja.com> schreef in berichtnieuws
8rvejm$8v6$1_at_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.
Received on Thu Oct 12 2000 - 04:19:52 CDT