-----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
