1Fermer3
nattoLe 04/12/2009 à 13:52
Quiche pawaaa grin

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.