Re: "views" as a column name

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 10 Oct 2000 18:25:01 +0100
Message-ID: <971199935.27148.0.nnrp-07.9e984b29@news.demon.co.uk>

Try quoting it in uppercase ...

    set "VIEWS" = 4

If this doesn't work, could you create a view to hide the column from PL/SQL

    create view xxx as
    select

        ....
        views    new_views,
        ...

    from test_views
    ;

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

keithdmiller_at_my-deja.com wrote in message <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 Tue Oct 10 2000 - 12:25:01 CDT