arrays and Oracle
From: Tomasz Wojcik <wojcik_at_psja1.if.uj.edu.pl>
Date: Fri, 15 Feb 2002 18:55:28 +0100
Message-ID: <3C6D4B90.4000305_at_psja1.if.uj.edu.pl>
Hi!
[Quoted] 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. Received on Fri Feb 15 2002 - 18:55:28 CET
Date: Fri, 15 Feb 2002 18:55:28 +0100
Message-ID: <3C6D4B90.4000305_at_psja1.if.uj.edu.pl>
Hi!
[Quoted] 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. Received on Fri Feb 15 2002 - 18:55:28 CET