RE: Getting spatial data?

-----Original Message-----
From: Todd Chisholm
Sent: Thursday, June 22, 2006 1:54 PM
Subject: Getting spatial data?

my $query = "select geometry from processed_product where id=15601";
my $sth = $connect->prepare($query);
$sth->execute();

[snip]

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.

You can't use native PL/SQL object types directly in Perl. You'll have
to select just the properties you need in the select clause, like:

select geometry.get_dims() from processed_product where id=15601

Can't call method "execute" on an undefined value at ...oracleTst.pl
line
12.

Just nit picking here, but don't forget "|| die $connect->errstr"
after your prepare statement.

Philip
.