[unixODBC-support] select on oracle table via unixODBC only returns partial result

Stefan.Immel at stroeher.de Stefan.Immel at stroeher.de
Fri Oct 10 15:45:21 BST 2014


Hi

I have a hugh problem regarding connect via unixODBC to an oracle DB.
when I try to select all records from a rather large table I only get very 
few as a result.

"select * from schema.table "
returns

>SQLRowCount returns -1
>162 rows fetched

whereas 

"select count(*) from schema.table "

returns
+-----------------------------------------+
| COUNT(*)                                |
+-----------------------------------------+
| 121116                                  |
+-----------------------------------------+
SQLRowCount returns -1
1 rows fetched


any idea what is causing this and how I can further debug it?


regards
Stefan Immel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20141010/b7632b99/attachment.html>


More information about the unixODBC-support mailing list