Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Suite - Version 126.96.36.199.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.
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