Remote procedure failing on every other call
748922Feb 17 2010 — edited Feb 17 2010Hello,
I'm having some problems with a remote procedure call. Both databases are Oracle 10g. This process is intended to run real-time as part of an application. However, every other record fails. I know the data is not an issue as I've used it in test blocks as described below. I've seen things like this in batch processing but never in real-time.
In database 1 (Oracle ERP), I have a pl/sql package that will create an RMA and create the transaction lines.
In database 2 (Amdocs CRM), I have a pl/sql package that will get all of the data elements and call the procedure in database 1. In this code, since it is in the calling database, there are commits after the procedure completes. This works, but every other record fails. There is no message returned from the remote procedure, doesn't even seem like it's being called. Haven't seen anything in the additional logging for the ERP API either. For this test I was using an anonymous pl/sql block with 3 records for processing.
If I take the same set of data used for testing in database 2 and run in database 1, all of the records work as expected, no failures.
Any suggestions on how to resolve?
Thanks,
Gary