Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remote procedure failing on every other call

748922Feb 17 2010 — edited Feb 17 2010
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2010
Added on Feb 17 2010
1 comment
497 views