On 7 nov, 15:48, Brian Tkatch <N/A> wrote:
> On Wed, 07 Nov 2007 03:28:18 -0800, eliot06 <p.hi...@gmail.com> wrote:
> >On 7 nov, 11:57, steph <stepha...@yahoo.de> wrote:
> >> On 7 Nov., 11:01, eliot06 <p.hi...@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
>
> >I connect the oracle vue with odbc onto access and it's ok, i can
> >upade delete insert but ni cannot with toad !!!!
>
> Well, than it is a TOAD problem, not an Oracle problem. This is
> probably not the correct forum for this.
>
> B.

yes, it's a toad free probleme!!! with toad licenced it's ok !!!

thank's