Re: Insert data into varray

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Fri, 29 Apr 2005 07:35:30 +0000 (UTC)
Message-ID: <d4so41$sbk$1@klatschtante.init7.net>

On 2005-04-28, Marcin 'dethar' Jurasz <dethar_at_gmail.com> wrote:
> Hi! Into my database (its part below), i'm trying to insert values.
>
> CREATE TYPE t_vphonenos AS VARRAY(3) OF VARCHAR2(15);
>
> CREATE OR REPLACE TYPE t_customer AS OBJECT (
> id number(4),
> name_1 varchar2(20),
> name_2 varchar2(20),
> surname varchar2(20),
> nip varchar2(13),
> regon varchar2(15),
> pesel varchar2(11),
> phone_nos t_vphonenos
> );
> /
>
> CREATE TABLE tab_customers OF t_customer (
> id PRIMARY KEY
> )
> OBJECT ID PRIMARY KEY
> /
>
> this works fine:
>
> INSERT INTO tab_customers VALUES(t_customer
> (1, 'Grzegorz', 'Adam', 'Jarzebski', '567nip', '678regon', '568pesel',
> t_adress('Osinska', '23', '24', 'Tuwima', '32-424', 'Towowka'),
> t_vphonenos('+48 565 565 565')));
>
> but now i'd like to insert ("add") some data into t_vphonenos (i've
> inserted one row already ;)). i've tried something like this, but it
> didn't work:
>
> INSERT INTO tab_customers (phone_nos) VALUES (
> t_vphonenos (
> ('123123123'),
> ('345345345')
> )
> );
> What i'm doing wrong? I've tried also:
>
> INSERT INTO TABLE (SELECT phone_nos FROM tab_customers WHERE id = 1)
> VALUES (t_vphonenos('123123','1231233'));
>
> Still doesn't work. Someone would help me?

INSERT INTO tab_customers (id, phone_nos) VALUES (

  1,   // <=============================================
 t_vphonenos (
          ('123123123'),
          ('345345345')
        )

 );

hth,
Rene

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

Received on Fri Apr 29 2005 - 02:35:30 CDT