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 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Oct-2010***


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.


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

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