| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
