Re: [Q] Pro*C: How many rows selected?

schnabl_at_aut.alcatel.at (Wolfgang Schnabl) wrote:
>A Pro*C question:
>Is there a possibility to get the number of rows selected after an
>OPEN CURSOR statement *before* doing a FETCH?
>(after the FETCH I can see the fetched rows in sqlca.sqlerrd[2]).
>
>or do I have to use "SELECT count(*)" first, which means actually doing
>the same call twice?
>
>I'm using Pro*C 1.5, ORACLE 7.1
>
Hi,
I doubt it,
and after all, even after the fetch, you get only what you've fetched so far, not all that may be fetched.
hth Received on Wed Oct 04 1995 - 00:00:00 CET