[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
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 SchnablReceived on Tue Oct 03 1995 - 00:00:00 CET
+-----------------+ 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