Thread: 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