You can't insert lobs that way at the moment. Do the insert directly and
not via PL/SQL.
Tim.
On Wed, Jul 31, 2002 at 06:55:08PM +0530, Sundarraj, Senthil Kumar (Cognizant) wrote:
> The below program fails with the following exception
> DBD::Oracle::st execute failed: (DBD ERROR: LOB refetch attempted for
> unsupport
> ed statement type) at insert_clob.pl (i.e at execute statement)
>
> what could be the problem?How to check which version of DBD am using?
>
> use DBI;
> use Oraperl;
> #use DBD::Oracle;
> #use strict;
> my ($sth, $stmt,$SQL, $return);
>
> $dbh= DBI->connect('dbi:Oracle:host=12.144.9.236;sid=ntt','tt','tt');
> $file = "This is a test\n"x100;
> $sth = $dbh->prepare(qq{
>
> BEGIN
>
> INSERT INTO lob_tab (EMPID,THE_LOB)
> VALUES (4,:text);
> END;
>
> });
>
> $sth->bind_param(':text',$file,{ ora_type => 112,ora_field=>'the_lob'});
> $sth->execute();
> $dbh->disconnect;
>
>
> Senthil Kumar
> 3rd Floor,27,Whites Rd
> ph # 044 - 8529917/8526917 x : 3791
>
> This e-mail and any files transmitted with it are for the sole use of the intended
>recipient(s) and may contain confidential and privileged information.If you are not
>the intended recipient, please contact the sender by reply e-mail and destroy all
>copies of the original message.
> Any unauthorised review, use, disclosure, dissemination, forwarding, printing or
>copying of this email or any action taken in reliance on this e-mail is strictly
>prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com
