Quiche pawaaa
DECLARE PROCEDURE myproc IS
CURSORS cur IS SELECT champ1, champ2, champ3 FROM matable WHERE moncul IS NOT NULL;
BEGIN
FOR row_cur IN cur LOOP
dbms_output.put_line('champ1=' || escape(row_cur.champ1) ||';'|| 'champ1=' || escape(row_cur.champ2) ||';'|| 'champ3=' || escape(row_cur.champ3) ||';');
END LOOP;
END ;
/
SQLPLUS> set serveroutput on
SQLPLUS> set feedback off
SQLPLUS> spool /tmp/proot.tmp
SQLPLUS> exec myproc
SQLPLUS> spool off
Ca devrait marcher sans consommer de memoire excessivement, enfin teste par toi meme.