Problem with Cursor in Oracle from Postgresql via ODBC - Mailing list pgsql-general

From Thomas Radnetter
Subject Problem with Cursor in Oracle from Postgresql via ODBC
Date
Msg-id 16160.1127843805@www19.gmx.net
Whole thread Raw
List pgsql-general
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

--
5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail
+++ GMX - die erste Adresse f�r Mail, Message, More +++

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: restore
Next
From: Damon Hart
Date:
Subject: Re: ERROR: type "temp_gc" already exists