DBI v1.14, DBD::Oracle v1.06
All, I have a module containing methods I use all the time on IRIX and
Win32 boxes to pull data stored in CLOB fields from a table stored on a
Solaris DB machine. For the first time today I tried using this SAME method
in a perl CGI script and got nothing back.
No errors, not a whisper of complaint from Oracle. Just silence and no
data. Has anyone run into this problem before? It seems to be JUST within
perl CGI scripts. Here's the relevant portion of the subroutine:
my $sql =<<E_SQL_E;
SELECT sequence
FROM Clone
WHERE isolate_id = $params{-id}
E_SQL_E
my $sth = $dbh->prepare($sql) or confess $DBI::errstr;
$sth->{LongReadLen} = 2**16-2;
$sth->{LongTruncOk} = 0;
$sth->execute() or confess $DBI::errstr;
my ($seq) = $sth->fetchrow_array();
return $seq;
$seq is returned as undef ... and $DBI::errstr is always empty! Advice
appreciated ...
- jc
-------------------------------------------------
James Diggans Phone: 301.987.1756
Gene Logic, Inc. FAX: 301.987.1701
[EMAIL PROTECTED] Cell: 301.908.2477
-------------------------------------------------
========================================================
The information contained in this email message is intended only
for the personal use of the recipient(s) named above. This
message may be privileged and confidential and protected from
disclosure. If the reader of this message is not the intended
recipient or an agent responsible for delivering it to the intended
recipient, you are hereby notified that you have received this
document in error and that any review,dissemination, distribution,
or copying of this message is strictly prohibited. If you have
received this communication in error, please notify us immediately
by email, and delete the original message.
========================================================
