SEO

#1 (**permalink**) 02-26-2008, 07:46 AM

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

#2 (**permalink**) 02-26-2008, 07:46 AM

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

#3 (**permalink**) 02-26-2008, 07:46 AM

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 !!!!

#4 (**permalink**) 02-26-2008, 07:46 AM

eliot06 wrote:

> And i can't update or insert or delete !!! anything

Show us the error you get.

-----
échangez opinions et commentaires dans les forums de discussion.
http://www.usenetgratuit.com/

#5 (**permalink**) 02-26-2008, 07:46 AM

On 7 nov, 13:14, vitalis...@gmail.com (Jerome Vitalis) wrote:
> eliot06 wrote:
> > And i can't update or insert or delete !!! anything
>
> Show us the error you get.
>
> -----
> échangez opinions et commentaires dans les forums de discussion.http://www.usenetgratuit.com/

I have no error message, but the toad keybox is seems to locked! !

#6 (**permalink**) 02-26-2008, 07:46 AM

On 7 Nov, 12:57, eliot06 <p.hi...@gmail.com> wrote:
>
> I have no error message, but the toad keybox is seems to locked! !

Re-try what you're doing in a SQL*Plus session and paste the exact
error message here.

HTH

-g

#7 (**permalink**) 02-26-2008, 07:46 AM

On Wed, 07 Nov 2007 03:28:18 -0800, eliot06 <p.hirth@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.

#8 (**permalink**) 02-26-2008, 07:46 AM

eliot06 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

Look at user_updatable_columns.

SELECT table_name, column_name, updatable, insertable, deletable
FROM user_updatable_columns
WHERE table_name IN (
SELECT view_name
FROM user_views);
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#9 (**permalink**) 02-26-2008, 07:46 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

canot update view