count of cusor active set items

From: Steve <wade_at_mit.edu>
Date: Fri, 10 Jul 1998 13:26:01 -0400
Message-ID: <35A64EA6.9299181D@mit.edu>

Hi,

Is it possible to obtain the number of items in the active set of a cusor when
using Pro*C?

The Fetch command in Pro*C fills in sqlca.sqlerrd[2] with the number of records retrieved. But, it seems that you need to fetch all records just to obtain
the count of the active set.

The only other alternative seems to be to issue another SQL call (e.g. select count(*) ...) along with the actual select call.

Thanks for any ideas, Received on Fri Jul 10 1998 - 12:26:01 CDT