All Forums Teradata Studio
sharonn 9 posts Joined 05/16
11 Aug 2016
Why is the first dynamic result set in a procedure is empty?

I have a procedure that has 1 dynamic result set defined in it.
When i call the procedure from TD studio i get 2 result sets:
1) Empty - no rows and no columns
2) My result set
When i call it from c# application i get only 1 - my result set.
 The problem is that i need 15 result sets (the maximum allowed) and the first empty one is "stealing" one of them.
is there a way to remove the first empty result set?

fgrimmer 553 posts Joined 04/09
11 Aug 2016

Sharon, This problem has been fixed in our upcoming 15.12 release. The problem was that the database was returning an empty result set if there were no out parameters. 

sharonn 9 posts Joined 05/16
16 Aug 2016

Thank you 

fgrimmer 553 posts Joined 04/09
08 Sep 2016

Sharon, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.

You must sign in to leave a comment.