Re: No of rows processed

Murali,

A fetch by nature only returns one row at a time, very similar to a read random read from isam/vsam files, where the where clause determines the exact rowid. A sinfle fetch statement will always return one row, if using array processing, with pl/sql using pl/sql table datatype add the a manual counter to the loop processing the fetches. If using the proc array method, after a set of fetches, loop through your host array and count the # of elements.

Hope this helps,

--
Vikram Goel                                
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:                              Motorola email: vgoel_at_pts.mot.com
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 

In article <31C8E178.FC0_at_kapalua-inc.com>, Muralidhar Krishnaprasad <kmurli_at_kapalua-inc.com> writes:


>HI 

>

> I am using ofen to batch fetch a number of rows for a SQL query in 


>OCI. I would like to find out the actual number of rows returned

>in that fetch. 

>

>The cda field rpc gives the total number of rows processed  for the

>cursor and even if I make it zero before calling ofen again it

>magically gets the total number of rows processed for the cursor. 

>

>If someone can throw some light on this matter it would be great!

>

>Thanks

>Murali