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?
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.
Sharon, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.