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 +++ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
