SpiritOfLennon
IS-IT--Management
Hi,
I have written a fairly simple PL/SQL script that is to be used for reverse engineering to interfaced databases, prior to implementing a new interface between the two. Unfortunately one of the issues of the first interface was that the interface kept no direct audit between the two databases, so the routine has to check for duplicate record matches and mark them as queries for manual review. The procedure works fine for simple transactions, however as soon as I try to process a record with duplicates in it rather than perform the necessary updates I get the following errors.
Details:
ORA-02055: distributed update operation failed; rollback required
ORA-01403: no data found
ORA-06512: at "METRIXP.CUTOVER_METRIX_VS3", line 227
ORA-06512: at line 2
Now I appreciate that nobody is gonna want to wade through 500 lines of my code and try and figure out the problem, but if somebody can give me some pointers as to possible problems I would appreciate it.
SOL
I'm only guessing but my guess work generally works for me.
I have written a fairly simple PL/SQL script that is to be used for reverse engineering to interfaced databases, prior to implementing a new interface between the two. Unfortunately one of the issues of the first interface was that the interface kept no direct audit between the two databases, so the routine has to check for duplicate record matches and mark them as queries for manual review. The procedure works fine for simple transactions, however as soon as I try to process a record with duplicates in it rather than perform the necessary updates I get the following errors.
Details:
ORA-02055: distributed update operation failed; rollback required
ORA-01403: no data found
ORA-06512: at "METRIXP.CUTOVER_METRIX_VS3", line 227
ORA-06512: at line 2
Now I appreciate that nobody is gonna want to wade through 500 lines of my code and try and figure out the problem, but if somebody can give me some pointers as to possible problems I would appreciate it.
SOL
I'm only guessing but my guess work generally works for me.