C ++ ResultSet rowCount

Question

Hello. I connected to the server, executed the query, go through all the values via ResultSet :: rs-> next (). Everything works as a whole.

How can I find out the number of lines without sorting? I know about "select count (*) ...", but this is absolutely not the case. I need to know the number of rows in the already returned query.

Result :: rs-> getNumArrayRows () returns 0, always.

I work through OCCI, compile GCC in Ubuntu 12.04

orkaan orkaan 708 3 silver marks 8 bronze marks · Accepted Answer · 2012-11-22T12:21:43

It seems to be impossible.

Now, if you could use a bunch of PL / SQL and your functionality in C ++, it would be cool ... And Google said, it is possible:

Here is the work with collections: http://docs.oracle.com/cd/B14117_01/appdev.101/b10778/objects.htm#sthref340
Here are their attributes: http://docs.oracle.com/cd/B14117_01/appdev.101/b10778/metadata.htm#sthref595

Those. what is the solution. Filling the so-called. arrays are executed on the Oracle server through cursors and collections, select not used . The collection / array has a count property, which, in the OCCI interpretation, seems to be an attribute of ATTR_NUM_ELEMENTS . Here you could use it if you rewrote the existing functionality.

C ++ ResultSet rowCount

1 answer 1

More articles: