'varray' haven't hear of that in years. At least not since Nested Tables
came along . I aways thoght they were for PL/SQL only.
I will have a look at them later this week. I am just wondering how one want
to look at the data in DBI??
Can you give me a quick working example of what you want to do and an
example of what you want to see in the end?
cheers
John Scoles
----- Original Message -----
From: "Tim Bunce" <[EMAIL PROTECTED]>
To: "Charles Pareto" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <dbi-users@perl.org>
Sent: Wednesday, June 06, 2007 4:39 AM
Subject: Re: DBD-Oracle VARRAY not supported
On Tue, Jun 05, 2007 at 05:03:23PM -0700, Charles Pareto wrote:
Hi Tim,
[...] All I'm looking for is a way to select a column that is defined
as type varray.
Is there any way this can be accomplished using DBD-Oracle or anything
else?
For simple data you could use SQL statements to convert the info into a
string.
There are probably better ways (returning ref cursor, pipelined function
etc)
but I'm a little out of touch with Oracle these days. Check google and
the archives.
Of course, the best option would be to implement proper support for
varrays.
That's probably not to difficult. I'll say "patches welcome" on behalf of
Pythian,
who are the lead maintainers.
Tim.
p.s. Don't use cpanforum. Very few people read it. The dbi-users@perl.org
list
is the best place to get help.
