Re: canot update view

On Wed, 07 Nov 2007 03:28:18 -0800, eliot06 <p.hirth_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. Received on Wed Nov 07 2007 - 08:48:38 CST