No more row indicator in OCI for PL/SQL calls???

In my OCI program i am executing a PL/SQL stored procedure that can bring back 0 to many rows of data. Since its a stored procedure i have to bind my result set to my programs local variables, then call oexec until i don't get any more rows back. For each invocation of oexec my locals will get filled with the results.

My question is, how do i know when to stop looping? Does oexec bring back some kind of result code when there are no rows returned? Do i have to use another function to retrieve the result sets.

I'd use an array of structures to hold my results, but i will not know the amount of rows i'll get back. Therefore i can't allocate the array. Is this a correct assumption?

Thanks for any help!

-David M Rosner
-dave_at_digidem.com

-------------------==== Posted via Deja News ====-----------------------

      http://www.dejanews.com/ Search, Read, Post to Usenet Received on Tue Jan 27 1998 - 00:00:00 CST