DB Adapter Wizard in JDeveloper is unable to Create the WSDL when PUBLIC SYNONYM is Used
(Doc ID 1918809.1)
Last updated on MARCH 19, 2019
Applies to:Oracle SOA Suite - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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.
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