Hi,
I m getting 'Oracle type not supported' error when I try to compile some
of my sql statements. The code snippet and error message is listed below.
_Error Message:_
/Field 105 has an Oracle type (108) which is not explicitly
supported at /arudev/lib/perl5/site_perl/5.8.6/i686-linux/DBD/Oracle.pm
line 304./
_My code snippet:_
/my $sql = "SELECT * FROM hz_locations "
." where location_id = :1 and actual_content_source = 'DNB'";
my $sth;
if ( $sth = $dbh->prepare($sql) ) {
for (my $loop = 0; $loop < $sth->{NUM_OF_FIELDS}; $loop++) {
push @db_cols, [$sth->{NAME}[$loop],
$self->{DT_TO_NAME}->{$sth->{TYPE}[$loop]}
|| "unknown"];
}
}/
Can you please help me regarding this issue? I just want those fields
with the special type to be ignored and the rest of my sql be compiled
or processed by $dbh->prepare subroutine, so that I can get the field
names and data types.
Or can you please suggest if any latest version of DBI API solves this
issue?
The database table column (Field 105) details that is raising this error is:
/Name Null? Type/
----------------------------------------- --------
----------------------------
/GEOMETRY
MDSYS.SDO_GEOMETRY/
/
/And the API version details are:
/$DBI::VERSION = "1.39"; # ==> ALSO update the version in the pod text
below!
$DBD::Oracle::VERSION = '1.14';/
Thanks,
Vijay
