Re: Insert data into varray

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Fri, 29 Apr 2005 21:37:05 +0000 (UTC)
Message-ID: <d4u9e1$kvk$2@klatschtante.init7.net>

On 2005-04-29, Marcin 'dethar' Jurasz <nick_at_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/

Received on Fri Apr 29 2005 - 16:37:05 CDT