DB Adapter Wizard in JDeveloper is unable to Create the WSDL when PUBLIC SYNONYM is Used (Doc ID 1918809.1)

Last updated on MARCH 27, 2020

Applies to:

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.

Changes

Cause

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