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

From: Wolfgang Schnabl <schnabl_at_aut.alcatel.at>
Date: 1995/10/03
Message-ID: <44rgvd$js1_at_atusks02.aut.alcatel.at>#1/1


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

        Thanx, Wolfgang.

--
         V           Dr. Wolfgang Schnabl               

+-----------------+ Alcatel Austria AG / Dept. CGP (tel) +43-1-27722-3059
| A L C A T E L | Scheydgasse 41 (fax) +43-1-27722-171
+-----------------+ A-1210 Wien (email) Wolfgang.Schnabl_at_aut.alcatel.at
Received on Tue Oct 03 1995 - 00:00:00 CET

Original text of this message