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

From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1995/10/03
Message-ID: <44s4a7$ref_at_homer.alpha.net>#1/1


Wolfgang Schnabl (schnabl_at_aut.alcatel.at) 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]).
  This would not tell you the total rows fetched after the   first fetch.

> or do I have to use "SELECT count(*)" first, which means actually doing
> the same call twice?
  i think so

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************
Received on Tue Oct 03 1995 - 00:00:00 CET

Original text of this message