I have a Java Stored Procedure created using the Teradata Plug-in for Eclipse, which works perfectly on Teradata V13.
But when I try to install it on Teradata V12 I receive the message
LANGUAGE JAVA *** Failure 3706 Syntax error: Java Language does not support DYNAMIC RESULT SETS in this release. Statement# 1, Info =183
Weren't DYNAMIC RESULT SETS a new feature of V12? Does anybody know any work-around?
Dynamic result sets for SQL stored procedures are a Teradata Database 12.0 feature.
Dynamic result sets for Java stored procedures are a Teradata Database 13.0 feature.
The "workaround" is to use Teradata Database 13.0, because that is the earliest release that contains the feature you are trying to use.
Thank you very much for your answer. I supposed the possibility to use them in Java because the Release 12 Documentation ( http://www.info.teradata.com/edownload.cfm?itemid=071940001 ), speaking about Dynamic Result Sets, refers also to Teradata JDBC driver.
Do you have an idea if installing JDBC 18.104.22.168 driver on TeraData R12 could help? (I’m following what suggested in http://downloads.teradata.com/download/connectivity/teradata-jdbc-driver-13-0-0-6 , the section What’s New of the README).
Thank you again, Raffaele.
Ok, unfortunately release 12 is not our choice, we will find out a software solution. Thank you very much for your assistance.