ORA-03124: two-task internal error

[E R]

I'm running into a ORA-03124 error on this code:

use DBI;

my $source = 'dbi:Oracle:host=...;port=...;sid=...';

my $id = "1258315613-22011-747584";

my $dbh = DBI->connect($source, "user", "password");

my $row = $dbh->selectrow_hashref("SELECT * FROM ORDERS WHERE (ORDERID
= ?)", {}, $id);
print "row = $row\n";

However, if I just add a space to the query string, I don't get the
error. In case it is important, the row exists.
Also, removing a space and adding it somewhere else (to keep the query
length the same) results in the query working.

I've reproduced this using perl 5.8.8 + DBI 1.607 and perl 5.10 + DBI 1.609.

Is there anything else I can do to find out what's going on?

Thanks,
ER

[John Scoles]

The ora-03124 has nothing to do with DBB::Oracle as this is either a
disk/space issue a lisence issue (as in you do not have the correct
one) or you are trying to stuff too much data into a single row or
field.
You will have to look at you oracle logs to see what is going wrong. As
it ran once I would go the too much data in a row or field and it might
have something to do with non UTF8 chars

Could the data be sored as UTF8??

can you give us an idea what the table structure is??

You might want to talk to your DBA?

> Date: Thu, 19 Nov 2009 16:04:32 -0600
> Subject: ORA-03124: two-task internal error
> From: pc88...@gmail.com
> To: dbi-...@perl.org

_________________________________________________________________
Eligible CDN College & University students can upgrade to Windows 7 before Jan 3 for only $39.99. Upgrade now!
http://go.microsoft.com/?linkid=9691819