CLOB insert with bind_param problem

[Stacy Mader]

Hi all.

Using DBI 1.28 and DBD::Oracle 1.12 compiled against Oracle 8.1.7,
I have the following:

use strict;
use DBI;

$text = "This is a test.\n"x6000;

$sth = $dbh->prepare(qq{
  
  DECLARE next NUMBER;
          
  BEGIN
    
  SELECT MAX(NUM+1) INTO next FROM REPORT;
  
  INSERT INTO EXCESS (ID,TEXT) 
    VALUES (next,:text)
      RETURNING next INTO :rv;
  
  END;
  
});

$sth->bind_param(":text","$text", { ora_type => 112 });
$sth->bind_param_inout(":rv",\$rv, 5);
$sth->execute();

print "$rv\n";

$dbh->disconnect;


This script fails at the execute statement with the message:

DBD::Oracle::st execute failed:  (DBD ERROR: 
LOB refetch attempted for unsupported statement type)


This I don't understand. The table 'EXCESS' is defined with two columns,
ID (type number) and TEXT (type CLOB). Any clues?


Regards,

        Stacy.