Re: arrays and Oracle
From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 15 Feb 2002 21:26:23 +0300
Message-ID: <a4jjlv$f5n$1_at_babylon.agtel.net>
Date: Fri, 15 Feb 2002 21:26:23 +0300
Message-ID: <a4jjlv$f5n$1_at_babylon.agtel.net>
[Quoted] [Quoted] How about using nested tables instead of varrays?
-- Vladimir Zakharychev (bob_at_dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Tomasz Wojcik" <wojcik_at_psja1.if.uj.edu.pl> wrote in message news:3C6D4B90.4000305_at_psja1.if.uj.edu.pl...Received on Fri Feb 15 2002 - 19:26:23 CET
> 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.
>