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