[GENERAL] Problem with Cursor in Oracle from Postgresql via ODBC

2005-09-27 Thread Thomas Radnetter
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 E

[GENERAL] how to loop until eof in a cursor with pgsql

2005-06-07 Thread Thomas Radnetter
hi folks, any idea how to loop through a cursor until it's eof? i'll try to do it this way: declare cursor . (with param) open cursor (param); fetch into record while found ... anything here fetch into record end loop am i right? can not try it at the moment. any suggestio

[GENERAL] export data into xml

2005-04-20 Thread Thomas Radnetter
hello everybody! i just subscribed to the list, so hello to all friends of pgsql. now here is my concrete problem: i have to exchange data with an other company. they are running a ms sql 2000 serer and want to import our data via xml. so, how do i get it out of the pgsql database? i looked in