Thread: Problem with Cursor in Oracle from Postgresql via ODBC

Problem with Cursor in Oracle from Postgresql via ODBC

From
"pofesen pofesen"
Date:
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


Re: Problem with Cursor in Oracle from Postgresql via ODBC

From
Johann Zuschlag
Date:
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


Re: Problem with Cursor in Oracle from Postgresql via ODBC

From
"Dave Page"
Date:
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

Re: Problem with Cursor in Oracle from Postgresql via ODBC

From
Richard Huxton
Date:
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