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

Nick Gorham nick at lurcher.org
Fri Oct 10 16:00:34 BST 2014


On 10/10/14 15:45, Stefan.Immel at stroeher.de wrote:
> 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?

Well, you can turn on odbc tracing in odbcinst.ini

[ODBC]
Trace=Yes
TraceFile=/tmp/sql.log

That may show a SQLFetch returning a unexpected error. I do very much 
doubt its down to unixODBC though, I would think its driver related.

-- 
nick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20141010/fc2c6634/attachment.html>


More information about the unixODBC-support mailing list