Why is the first dynamic result set in a procedure is empty?

Teradata Studio
Enthusiast

Why is the first dynamic result set in a procedure is empty?

Hi,

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?

Thanks

3 REPLIES
Teradata Employee

Re: Why is the first dynamic result set in a procedure is empty?

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. 

Enthusiast

Re: Why is the first dynamic result set in a procedure is empty?

Thank you 

Teradata Employee

Re: Why is the first dynamic result set in a procedure is empty?

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