Hi,
I'm trying use OraParameter objects to to a batch insert against a table. When I actually execute the SQL statement, I am getting a 4139 error (something to do with Arrays), and consulting the associated error log, I find it to be full of junk like this:
Here's the problem - there is no way that this data is causing an error against the unique key it names. No way. I've deleted all possible values that could be used prior to running the query (same transaction as the Insert), and part of the key is a sequential number...
And this is where it gets really freaky - I've written some code to take the OraParameters objects, and use them to work out a load of simple sql statements to use in their place, and lo and behold that goes through without any problems!
Anyone got the slightest idea what's going on?
Martin
I'm trying use OraParameter objects to to a batch insert against a table. When I actually execute the SQL statement, I am getting a 4139 error (something to do with Arrays), and consulting the associated error log, I find it to be full of junk like this:
ORA-00001: unique constraint (NJT_UAT.ROSDET_UKY) violated
, Message 201 not found; No message file for product=OO4O, facility=OIP 1
ORA-00001: unique constraint (NJT_UAT.ROSDET_UKY) violated
, Message 201 not found; No message file for product=OO4O, facility=OIP 2
ORA-00001: unique constraint (NJT_UAT.ROSDET_UKY) violated
, Message 201 not found; No message file for product=OO4O, facility=OIP 3
ORA-00001: unique constraint (NJT_UAT.ROSDET_UKY) violated
, Message 201 not found; No message file for product=OO4O, facility=OIP 4
ORA-00001: unique constraint (NJT_UAT.ROSDET_UKY) violated
, Message 201 not found; No message file for product=OO4O, facility=OIP 5
....
Here's the problem - there is no way that this data is causing an error against the unique key it names. No way. I've deleted all possible values that could be used prior to running the query (same transaction as the Insert), and part of the key is a sequential number...
And this is where it gets really freaky - I've written some code to take the OraParameters objects, and use them to work out a load of simple sql statements to use in their place, and lo and behold that goes through without any problems!
Anyone got the slightest idea what's going on?
Martin