:56 PM
Subject: RE: DBD-Oracle VARRAY not supported
This works, but can you search for a specific value within a varray?
Charles Pareto
Brand Protection Engineer
[EMAIL PROTECTED]
408-525-5505
-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 14, 2007 10
@perl.org
Subject: Re: DBD-Oracle VARRAY not supported
Well I have had a look into it and I do not think there is anything in
DBD::Oracle we have to do to make varray work as it is simple SQL and is
handled at the OCI level of the SQL commnd
For example the following script works without any issues
PROTECTED]
To: 'John Scoles' [EMAIL PROTECTED]
Cc: dbi-users@perl.org; [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2007 12:18 PM
Subject: RE: DBD-Oracle VARRAY not supported
Sure, here is my example-
I'm declaring a column as type varray like this:
CREATE TYPE phone as varray(20) of varchar2(30
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