Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.mailgate.org!news-zh.switch.ch!switch.ch!news.imp.ch!news.imp.ch!newsfeeder.eunet.ch!nntp.init7.net!not-for-mail
From: Rene Nyffenegger <rene.nyffenegger@gmx.ch>
Newsgroups: comp.databases.oracle.server
Subject: Re: Insert data into varray
Date: Fri, 29 Apr 2005 21:37:05 +0000 (UTC)
Organization: ADP Analyse, Design & Programmierung GmbH
Lines: 23
Message-ID: <d4u9e1$kvk$2@klatschtante.init7.net>
References: <bfa38817.0504281237.6326@posting.google.com> <d4so41$sbk$1@klatschtante.init7.net> <whn9fhttztpo.1shetw8fxr1ke.dlg@40tude.net>
NNTP-Posting-Host: adsl-133-50.init7.net
X-Trace: klatschtante.init7.net 1114810625 21492 213.144.133.50 (29 Apr 2005 21:37:05 GMT)
X-Complaints-To: abuse@init7.net
NNTP-Posting-Date: Fri, 29 Apr 2005 21:37:05 +0000 (UTC)
User-Agent: slrn/0.9.8.1 (CYGWIN_NT-5.1)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:241691

On 2005-04-29, Marcin 'dethar' Jurasz <nick@op.pl> wrote:
> Fri, 29 Apr 2005 07:35:30 +0000 (UTC), Rene Nyffenegger wrote:
>
>> INSERT INTO tab_customers (id, phone_nos) VALUES (
>>   1,   // <=============================================
>>  t_vphonenos (
>>           ('123123123'),
>>           ('345345345')
>>         )
>>  );
>
> Unique constraint violated :P. :). I tried many combinations, also
> modified from psoug.org, but... still got problem. Thanks anyway ;).

Yeah, this 1 is was only a placeholder. Use a sequence instead.

hth
Rene


-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/