MQSeries.net :: View topic - ORA-24333: zero iteration count

ChrisBUK · Posted: Wed Feb 11, 2009 4:02 am Post subject: ORA-24333: zero iteration count

Hi,
Started getting this error sporadically when calling a stored procedure with 12 dynamic result sets.
There is a possibilty this same flow was exectued in 4 or 5 execution groups if a batch of messages came through at once.
Isnt the dynamic result set as part of a create procedure new functionailty in V6?
If so, why cant it seem to cope with mutliple calls from different execution groups?
I dont really want to change this to 12 seperate selects in the flow as we could end up with too many cursors being open, hence the use of the stored procedure.

Ive seen the suggestion to Set the environment variable MQSI_EMPTY_DB_CACHE=Y, but how can i find out what this variable is currently set to?

TIA,
Chris