Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insert data into varray

Insert data into varray

From: Marcin 'dethar' Jurasz <dethar_at_gmail.com>
Date: 28 Apr 2005 13:37:58 -0700
Message-ID: <bfa38817.0504281237.6326@posting.google.com>


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?

Thanks Received on Thu Apr 28 2005 - 15:37:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US