[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


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 "

>SQLRowCount returns -1
>162 rows fetched


"select count(*) from schema.table "

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

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

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