I have problem using Oracle Intermedia queries with DBI modules. My code works with
regular queries (Example Below) and Intermedia works from sqlplus. But, from the
script with DBI I don�t get any results when I convert my queries to Intermedia
syntax. Can DBI handle Intermedia syntax?
Here is sample Code for each:
Regular query: [ select i_id,description from items where upper(description) like
'%BOOK' ; ]
Sample Perl Code (WORKS):
my $term = "%BOOK%";
$query =qq{select i_id,description from items where (upper(description) like ?)
};
$dbh = DBI->connect($DATABASE, $USERNAME, $PASSWD, "Oracle")
or die "Can't connect to database $DATABASE: $DBI::errstr";
$q = $dbh->prepare($query) or die 'cannot prepare';
$q->execute($term);
while (($id,$description) = $q->fetchrow_array()){
print "$id => $description \n";
}
$q->finish;
$dbh->disconnect;
----------------------------------------------
Intermedia query: select i_id, description from items where (contains
(description,'BOOKS') > 0);
Sample Perl Code (Does NOT WORK):
my $term = "BOOK";
my $query = qq{select i_id, description from items where (contains (description,?)
> 0 )};
$dbh = DBI->connect($DATABASE, $USERNAME, $PASSWD, "Oracle")
or die "Can't connect to database $DATABASE: $DBI::errstr";
$q = $dbh->prepare($query) or die 'cannot prepare';
$q->execute($term);
while (($id,$description) = $q->fetchrow_array()){
print "$id => $description \n";
}
$q->finish;
$dbh->disconnect;
I appreciate any Help.
-Bardia