Skip site navigation (1) Skip section navigation (2)

Problem with Cursor in Oracle from Postgresql via ODBC

From: "pofesen pofesen" <pofesen(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Problem with Cursor in Oracle from Postgresql via ODBC
Date: 2005-09-28 13:27:34
Message-ID: BAY13-F23C003B83F9A4B77B671DDAB8D0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-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


Responses

pgsql-odbc by date

Next:From: Richard HuxtonDate: 2005-09-28 16:16:28
Subject: Re: Problem with Cursor in Oracle from Postgresql via ODBC
Previous:From: Dave PageDate: 2005-09-28 08:38:50
Subject: Re: PostgreSQL / ODBC / Ms-SQL 2000

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group