I am not familiar with the "hasnext()" function. (Out of curiosity, what engine has that function?) Oracle has various boolean expressions that one can evaluate within loops and cursors.
To choose the best one for your needs, could you please give a "functional narrative" of exactly how "hasnext()" works?...For example, does "hasnext()" have a "true" value in the current loop iteration if it anticipates starting another loop iteration after completing this one?
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.