Re: ora 00904 Error ?

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Tue, 26 Oct 1999 12:52:21 +0200
Message-ID: <381587E5.1C934739@unilog.fr>

Hello !

I try this with Oracle 7.3.4 and have no problems.

May be one of the column name is a reserved word, so try to protect them like that :

update port set "LINK" = 2 where "ID" = 9;

Pierre Charpenay

Rene Kadner wrote :

> Hi,
>
> i have a simple table named "port" with two Number(*) - Fields 'id' and
> 'link'.
>
> I want update the table:
>
> update port set Link = 2 where id = 9.
>
> with an ORA 00904-Error ???
>
> MS SQL and Paradox execute this without errors.
>
> Who can help ?
> Thanks.
>
> Rene Kadner
> rkadner_at_shd-online.de
Received on Tue Oct 26 1999 - 05:52:21 CDT