Home » Developer & Programmer » Precompilers, OCI & OCCI » Bulk fetch of coloumn value (OCCI, windows)
Bulk fetch of coloumn value [message #327068] Fri, 13 June 2008 11:06
rajesh1978
Messages: 1
Registered: June 2008
Junior Member
Hi,
I am facing a very difficult problem. I have one table called Mydata(datavalue number(5)). It contains 50,000 records like

datavalue
---------
123
234
345
777
908
---
---

I use occi and C++ to access the table from oracle to C++.

I use refcursor to fetch the data. But the problem is
I need to use
while(rs->next())
{
process the data......
}

This iteration is taking around 15 seconds to fetch all the value from the table. I want to fetch the column values at a time.
I got some sample for this like
ResultSet *resultSet = stmt->executeQuery(...);
resultSet->setDataBuffer(...);
while (resultSet->next(numRows) == DATA_AVAILABLE)

But I am not able to implement the above.
Please anybody knows how to implement it then it will be very much useful to me.

Please provide me some code sample so that I can overcome my Problem

Thanks
Previous Topic: PRO*C compiler error
Next Topic: GLOBAL TEMPORARY TABLES from Pro*C
Goto Forum:
  


Current Time: Thu Mar 28 16:37:13 CDT 2024