|Bulk fetch of coloumn value [message #327068]
||Fri, 13 June 2008 11:06
Registered: June 2008
I am facing a very difficult problem. I have one table called Mydata(datavalue number(5)). It contains 50,000 records like
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
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(...);
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