Re: Problem with Cursor in Oracle from Postgresql via ODBC

From: Johann Zuschlag <zuschlag2(at)online(dot)de>
To: pofesen pofesen <pofesen(at)hotmail(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with Cursor in Oracle from Postgresql via ODBC
Date: 2005-09-28 17:06:47
Message-ID: 433ACDA7.5060004@online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

pofesen pofesen schrieb:

>
> In PL/SQL procedure I open a view on the PGSQL (8.0.3) DB into a cursor
> which i want to loop through until EOF. The View returns about 2.000
> rows,
> but always at the number of 100 rows, it just stops, like there are no
> more
> rows. But I know there are and a "normal" select statement gives me the
> correct result!
>
> Anybody has an idea? I would really appreciate.
>
>
Hi Thomas,

which version of psqlodbc you are using? It seems that you switched on
'cursor control' in the driver. There was a bug recently in that part of
the driver. I'm not sure whether that was fixed in the last version
(8.01.00.04).

regards

Johann

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Håkon Clausen 2005-09-28 17:35:11 Re: ODBC driver types
Previous Message Richard Huxton 2005-09-28 16:16:28 Re: Problem with Cursor in Oracle from Postgresql via ODBC