My Oracle Support Banner

DB Adapter - MS SQL Server stored procedure table type issue, 'BINDING.JCA-11819' (Doc ID 2104724.1)

Last updated on AUGUST 28, 2017

Applies to:

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

Goal

Calling a MSSQL Server stored procedure from DB Adapter the stored procedure accepts MSSQL User-Defined Table Type as the input parameter.
While creating the DB Adapter in JDev (11.1.1.6.0), getting below error:

Error:
BINDING.JCA-11819
Database type not supported.
Encountered a database type table type that is either not supported or is not implemented.
Parameter InsertDept_TVP is of type table type which is either not supported or is not an implemented datatype.
Check to ensure that the type of the parameter is one of the supported datatypes or that there is a collection or user defined type definition representing this type defined in the database.

at oracle.tip.adapter.db.sp.xsd.sqlserver.DatabaseBrowser.expandParameter(DatabaseBrowser.java:88)
at oracle.tip.adapter.db.sp.xsd.sqlserver.DatabaseBrowser.expandParameters(DatabaseBrowser.java:65)
at oracle.tip.adapter.db.sp.xsd.XSDGenerator.generateInputRootElement(XSDGenerator.java:312)
at oracle.tip.adapter.db.sp.xsd.XSDGenerator.generateXSD(XSDGenerator.java:373)


Upon introspection: [FMWGEN][SQLServer JDBC Driver]The specified SQL type is not supported by this driver.


Solution

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
Goal
Solution


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