Since you mentioned it was isolated to your CGI
scripts, I imagine you already know how to retrieve
the data, and Bodo Eing probably gave you the answer
you were looking for.
If not:
use DBD::Oracle qw(:ora_types);
$update_clob=$dbh->prepare(UPDATE table SET CLOB_FIELD
= ? Where ID="SOMEID");
$update->bind_param(1,$clob_text,
{ora_type=>ORA_CLOB});
$update->execute();
--- Bodo Eing <[EMAIL PROTECTED]> wrote:
> Subject: Oracle CLOBs through DBI through
> CGI.pm don't work?
> To: [EMAIL PROTECTED]
> From: [EMAIL PROTECTED]
> Date sent: Wed, 9 May 2001 18:36:12 -0400
>
>
> jc,
>
> your environment is far beyond my experience, but
>
> >
> > 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
>
> Does
>
> print $params{-id};
>
> really print your isolate ID entered into the form?
> If you are new to CGI.pm, perhaps you mean someting
> like $query->params('id') ?
>
> Bodo
>
> Dr. med. Bodo Eing
> Institut fuer Medizinische Mikrobiologie
> Klinische Virologie
> v.-Stauffenbergstr. 36
> 48151 Muenster
> Germany
>
> Phone: ++49 251 7793 111 Fax: ++49 251 7793-104
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
