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
