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
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