have done this before and have no problems. I will
send you the snippet tomorrow if you want.
you have to do:
use DBD:Oracle(:ora_types);
and then say which column is the CLOB.
I don't have the syntax in front of me. But will send
it off list tomorrow if someone else doesn't answer.
Job
--- [EMAIL PROTECTED] wrote:
>
> 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.
>
========================================================
>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
