DYNAMIC RESULT SETS and Teradata versions

Extensibility

DYNAMIC RESULT SETS and Teradata versions

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?

Tags (1)
4 REPLIES
Teradata Employee

Re: DYNAMIC RESULT SETS and Teradata versions

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.

Re: DYNAMIC RESULT SETS and Teradata versions

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 13.0.0.6 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.

Teradata Employee

Re: DYNAMIC RESULT SETS and Teradata versions

>>> Do you have an idea if installing JDBC 13.0.0.6 driver on TeraData R12 could help?

No, it will not.

Re: DYNAMIC RESULT SETS and Teradata versions

Ok, unfortunately release 12 is not our choice, we will find out a software solution. Thank you very much for your assistance.