From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | pofesen pofesen <pofesen(at)hotmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Problem with Cursor in Oracle from Postgresql via ODBC |
Date: | 2005-09-28 16:16:28 |
Message-ID: | 433AC1DC.4090209@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Johann Zuschlag | 2005-09-28 17:06:47 | Re: Problem with Cursor in Oracle from Postgresql via ODBC |
Previous Message | pofesen pofesen | 2005-09-28 13:27:34 | Problem with Cursor in Oracle from Postgresql via ODBC |