Re: Getting spatial data?

Great, thanks for your help guys. Right now, I'm getting it out with
getvertices. Didn't know how that worked. I may try the BLOB as well, to
streamline things, since I just need a dump of it.

Philip, I added the die command, thanks (usually they are there...really!)

Todd


On 6/22/06, John Scoles <scoles@xxxxxxxxxxx> wrote:

Tricky one.

The sdo_geometry is a very Oracle specific binary field as DBI and
DBD::Oracle basically default of strings so the program dies.

You may want to define the field as an "ora_type => ORA_CLOB" or
"ORA_BLOB"
and get it that way.

If may work.

I might have write a patch for it and treat it as a BLOB. (Tomorrow is my
DBD::Oracle day so I may get to look at it)

cheers John Scoles

----- Original Message -----
From: "Todd Chisholm" <todd.chisholm@xxxxxxxxx>
To: <dbi-users@xxxxxxxx>
Sent: Thursday, June 22, 2006 1:54 PM
Subject: Getting spatial data?


> Hi all,
>
> I'm trying to get some sdo data, but running into trouble. The program
> snippet:
>
> my $connect = DBI->connect( "dbi:Oracle:****",
> '****',
> '****',
> ) || die "No connect";
> #my $query = "select update_date from processed_product where id=15601";
> my $query = "select geometry from processed_product where id=15601";
> my $sth = $connect->prepare($query);
> $sth->execute();
>
>
> The result:
>
> DBD::Oracle::db prepare failed: ERROR OCIDefineObject call needed but
not
> implemented yet [for Statement "select geometry from processed_product
where
> id=15601"] at /home/corp14/tchishol/oracleTst.pl line 11.
> Can't call method "execute" on an undefined value at ...oracleTst.pl
line
> 12.
>
> The 'geometry' type is sdo_geometry. Anyone had luck working with this
type
> of data?
>
> Thanks,
> Todd
>