Re: Getting spatial data?

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


.