not related to your problem, but
use a sequence.
the max(num+1) is a bad idea.
Job
--- Stacy Mader <[EMAIL PROTECTED]> wrote:
>
> 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.
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
