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
