Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: canot update view

Re: canot update view

From: eliot06 <p.hirth_at_gmail.com>
Date: Thu, 08 Nov 2007 05:42:50 -0000
Message-ID: <1194500570.727693.279770@d55g2000hsg.googlegroups.com>


On 7 nov, 15:48, Brian Tkatch <N/A> wrote:
> On Wed, 07 Nov 2007 03:28:18 -0800, eliot06 <p.hi..._at_gmail.com> wrote:
> >On 7 nov, 11:57, steph <stepha..._at_yahoo.de> wrote:
> >> 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
>
> >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 Received on Wed Nov 07 2007 - 23:42:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US