Re: Arrays in Oracle

Tomasz Wojcik wrote:
>
> Hi!
> It is possible to store arrays of integer numbers (e.g. like in "c" int
> test[20] ) in Oracle?
> I've tried something like this:
> CREATE TYPE my_array AS VARRAY(300) OF NUMBER(2)
> CREATE TABLE my_table ( XXX my_array).
> And the problem is when I'm trying to insert some data to this table
> from proC/C++ code.
> How should I do this?
> If you have any tips please let me know.
> Best regards
> TomaszW.

insert into my_table values ( my_array(1,2,3,4,5,6) );

or thereabouts

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."