I would like to expose the teradata procedure as service, so i had included the below jar files to the Jdeveloper, iam able to connect to the database, thats fine, working.
terajdbc4.jar and tdgssconfig.jar
When i try to use database adapter to connect using the database connection, iam able to connect but when i try to select the Operation Type as Stored Procedure iam getting *"The adapter Configuration wizard doesnt support Teradata Stored Procedure"* Error.
As a workaround, we can use java class and call the java class from OSB. But really want to know, is Jdeveloper doesnt support browsing procedure on teradata schema ?
Or is there any problem with the JDeveloper ? Iam using JDeveloper Studio Edition version 220.127.116.11.0
The components of SQL Developer included in JDeveloper 18.104.22.168 are a bit out-of-date relative to our current release, but even with the latest JDeveloper 22.214.171.124 my guess would be that stored procedure browsing is not supported. Third-party database support in SQL Developer exists mainly for the purpose of migration to Oracle, so the Oracle SQL Developer Migrations: Supported Platforms documentation should apply, but even that may not be entirely current:
See the Teradata column in section *1.2 Supported Features*
SQL Developer Team