Обсуждение: Problem with Cursor in Oracle from Postgresql via ODBC

Hi everybody,

if someone get's confused by the subject, let me explain:

Oracle 10g on Linux with ODBC installation for DB-Link to Postgresql. That
works very fine!

But, now the problem:

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.


best regards,
thomas

_________________________________________________________________
So können Sie zu jeder Zeit die besten Suchfunktionen nutzen - die MSN
Toolbar. http://toolbar.msn.at?DI=43&XAPID=2170

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

No, it's not fixed yet. The guys at Pervasive are on the case :-)

/D

-----Original Message-----
From: "Johann Zuschlag"<zuschlag2@online.de>
Sent: 28/09/05 18:12:08
To: "pofesen pofesen"<pofesen@hotmail.com>, "pgsql-odbc@postgresql.org"<pgsql-odbc@postgresql.org>
Subject: Re: [ODBC] Problem with Cursor in Oracle from Postgresql via 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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend



-----Unmodified Original Message-----
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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

pofesen pofesen wrote:
> Hi everybody,
>
> if someone get's confused by the subject, let me explain:
>
> Oracle 10g on Linux with ODBC installation for DB-Link to Postgresql. That
> works very fine!
>
> But, now the problem:
>
> 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.

First step would be to turn logging on/up at both ends - see what is
being executed.

--
   Richard Huxton
   Archonet Ltd