Help
Date: 1998/10/17
Message-ID: <908642861.102821_at_si1-paris>#1/1
Hi,
[Quoted] I use ORACLE 7.2 on UNIX and I have creates a SQL procedure that stocks data
in a file text.
Unfortunately, i'm limited to one million of characters while using the
command
'set serveroutput on size 1000000'.
I look for a solution to get round the problem knowing that I cannot use
package UTL+AF8-FILE.
Please help me +ACEAIQAhACEAIQ-
PROCEDURE SQL :
set verify off
set termout on
set serveroutput off
set serveroutput on size 1000000
[Quoted] accept can+AF8-ven accept deb+AF8-per accept fin+AF8-per
spool toto.txt
DECLARE
cursor c1 is
[Quoted] select distinct annee, axe+AF8-can, axe+AF8-pays
from fact+AF8-a0+AF8-smp+AF8-ael+AF8-chi+AF8-uo26
where axe+AF8-can in (+ACY-can+AF8-ven)
and period between +ACY-deb+AF8-per and +ACY-fin+AF8-per
and axe+AF8-cli +AD0- -1
group by annee, axe+AF8-can, axe+AF8-pays+ADs-
cur1+AF8-annee NUMBER(4)+ADs- cur1+AF8-axe+AF8-can CHAR(2)+ADs- cur1+AF8-axe+AF8-pays CHAR(2)+ADs-
BEGIN open c1+ADsloop
[Quoted] fetch c1 into cur1+AF8-annee, cur1+AF8-axe+AF8-can, cur1+AF8-axe+AF8-pays+ADsexit when c1+ACU-notfound+ADs-
[Quoted] dbms+AF8-output.put+AF8-line(cur1+AF8-annee +AHwAfA- '+ADs-' +AHwAfA- cur1+AF8-axe+AF8-can +AHwAfA- '+ADs-' +AHwAfAcur 1+AF8-axe+AF8-pays)+ADs-
end loop+ADsclose
c1+ADs-
for i in 1..50 loop
[Quoted] dbms+AF8-output.put+AF8-line(' ')+ADs-
end loop+ADsEND
+ADs-
/
spool off
clear screen
Received on Sat Oct 17 1998 - 00:00:00 CEST