Re: canot update view

From: steph <stephan0h_at_yahoo.de>
Date: Wed, 07 Nov 2007 02:57:58 -0800
Message-ID: <1194433078.247047.50830@57g2000hsv.googlegroups.com>

On 7 Nov., 11:01, eliot06 <p.hi..._at_gmail.com> wrote:
> hi,
> someone could help me :
> I have create a vue :
>
> CREATE OR REPLACE VIEW MARKETING.VUE_JEULST026
> (
> NUCLI,
> TYNOM,
> NULST,
> NOLST,
> PRLST,
> ANNAISLST,
> MONAISLST,
> JONAISLST,
> NUCLI_MRK,
> NUCLI_ENT,
> COMPTE,
> NAME_ID,
> NUCLI_CARDEX,
> CD_CLIENT,
> ID_CLI,
> NUCLI_DEPOT,
> NUTIT
> )
> AS
> SELECT
> "NUCLI","TYNOM","NULST","NOLST","PRLST","ANNAISLST","MONAISLST","JONAISLST","NUCLI_MRK","NUCLI_ENT","COMPTE","NAME_ID","NUCLI_CARDEX","CD_CLIENT","ID_CLI","NUCLI_DEPOT","NUTIT"
> FROM marketing.jeulst026
> /
>
> And i can't update or insert or delete !!! anything
>
> Why

Hi,

Update or insert into a view is only working under certain circumstances. Maybe you should offer the information of your Oracle version. And maybe consultation of the manuals is also helpful (obviously ...).

cheers,
stephan Received on Wed Nov 07 2007 - 04:57:58 CST