Re: [Sqlrelay-discussion] ORA-01480 with long CLOBs?

[Alexander K. <ak-...@cy...>]

Hi David,

On Tue, Nov 06, 2007 at 10:43:01PM -0500, David Muse wrote:
> Sorry for the delay, I've been really busy and a little sick for the
> past couple of weeks.
No worries - thanks for the reply and glad to hear you're better ...

> If you could send me some example code then I'm sure I can track down
> the problem.

Here is some code that shows the problem. Apparently, the problem starts
at 65k+1:

use DBI;
use strict;
use warnings;

my $dbh = DBI->connect('dbi:SQLRelay:', 'user1', 'password1');

my $sth = $dbh->prepare('CREATE TABLE tmp (bla CLOB)');
$sth->execute() or die 'CREATE TABLE failed: ' . $dbh->err . ', ' . $dbh->errstr;

# this works just fine
$sth = $dbh->prepare_cached('INSERT INTO tmp VALUES (?)');
my @bind_values = ('A' x 65536);
$sth->execute(@bind_values) or die 'Insert failed: ' . $dbh->err . ', ' . $dbh->errstr;

# this fails with ORA-01480
$sth = $dbh->prepare_cached('INSERT INTO tmp VALUES (?)');
@bind_values = ('A' x 65537);
$sth->execute(@bind_values) or die 'Insert failed: ' . $dbh->err . ', ' . $dbh->errstr;

For what it's worth, here's some info on the Oracle instance I am using:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Thanks for your help,
Best regards,
  Alex
-- 
Dipl.-Math. Alexander Klink | IT-Security Engineer
        ak-...@cy... | working @ urn:oid:1.3.6.1.4.1.11417