Home » Developer & Programmer » Precompilers, OCI & OCCI » Number of rows fetched
Number of rows fetched [message #144656] Thu, 27 October 2005 10:07 Go to next message
GePs
Messages: 2
Registered: October 2005
Location: Torino, Italy
Junior Member
In OCI (the language is C), how can I know the number of rows fetched by a sql select? I can read the number of columns after executing a query with the OCIAttrGet() on a statement handle with the prameter OCI_ATTR_PARAM_COUNT set, but trying with the same function whit OCI_ATTR_ROW_COUNT I obtain nothing!!!!
please help me! GePs
Re: Number of rows fetched [message #150015 is a reply to message #144656] Tue, 06 December 2005 00:38 Go to previous message
kmohan
Messages: 28
Registered: July 2005
Junior Member
there are two ways: fetch all rows and keep a counter, or select count(*). If you are not selecting count(*), you will not know how many rows match your query criteria, till you actually fetch the rows.
Previous Topic: setMaxIterations API of OCCI not setting the max number of iterations
Next Topic: Error in compiling ProC program
Goto Forum:
  


Current Time: Fri Mar 29 07:58:16 CDT 2024