DB Adapter Wizard in JDeveloper is unable to Create the WSDL when PUBLIC SYNONYM is Used

(Doc ID 1918809.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

A stored procedure MY_PROC is defined within a package. The first parameter PARAM_1 of the procedure references a user-defined TABLE type MY_TAB_TYPE, e.g.

When configuring the Database Adapter in JDeveloper to call the stored procedure, everything works when the user-defined type is declared in the same schema MYUSER as the package.

But when the type is defined in a different schema OTHER_USER, with access granted to MYUSER and a PUBLIC SYNONYM created, there is an error when finishing the wizard:

Error while writing WSDL file . Exception:
WSDLException: faultCode=OTHER_ERROR: Database type not supported.
Encountered a database type PUBLIC.MY_TAB_TYPE that is either not supported or is not implemented.
Parameter PARAM_1 is of type PUBLIC.MY_TAB_TYPE which is either not support or is not implemented.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms