Integration

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SOA Testing Error

940356Jun 19 2012 — edited Feb 26 2020

I have called a stored PL/SQL procedure, compiling was good, deployment was also good, but when I tested my web service in the WLS, then the following error occurs :

Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'GetPrice' failed due to: Interaction processing error. Error while processing the execution of the BPEL_GETPRICE.TOPLEVEL$GET_PROD_DETAILS API interaction. An error occurred while processing the interaction for invoking the BPEL_GETPRICE.TOPLEVEL$GET_PROD_DETAILS API. Cause: java.sql.SQLException: invalid name pattern: APPS.ROWTYPE_SQLX582544X1X2 ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

Please help me to solve this problem.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2012

Added on Jun 19 2012

#business-process-management-suite, #soa-process-management

10 comments

644 views