My Oracle Support Banner

Apps Adapter Does Not Call Stored Procedures The Same Way As The Db Adapter (Doc ID 579368.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Oct-2010***


Symptoms

While trying to use the Apps R12 adapter as a partner link from a BPEL process to call the native create order API in R12, you click finish and a Processing popup appears. After about 10-20 minutes, it errors with

Error while writing wsdl file.



-- Steps To Reproduce:
Example: create an Apps adapter connection and call a PL/SQL API. If the PL/SQL is using standard parameter types, it woks okay.

If the PL/SQL is using non-standard parameter types (extensions that are non-standard: boolean, record, etc), then the adapter is supposed to generate a wrapper SQL procedure to handle these types but does not.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.