Hi ,
While programming in PL/SQL i came accross a problem ,
i created a FOR LOOP for generating nos 100 till 1(reverse order) and also checking whether the no. is ODD or EVEN .
After giving me a display from 100 till no. 29 , an error was flashed :
ORA-20000 : ORU-10027:BUFFER OVERFLOW , LIMIT OF 2000 BYTES
Please tell how do i handle this and get the complete output?
Secondly , if i want to REDIRECT the output of the PL/SQL program directly into any text file without showing it in the oracle screen , HOW CAN I DO THAT ????
Thanks,
Udit.
While programming in PL/SQL i came accross a problem ,
i created a FOR LOOP for generating nos 100 till 1(reverse order) and also checking whether the no. is ODD or EVEN .
After giving me a display from 100 till no. 29 , an error was flashed :
ORA-20000 : ORU-10027:BUFFER OVERFLOW , LIMIT OF 2000 BYTES
Please tell how do i handle this and get the complete output?
Secondly , if i want to REDIRECT the output of the PL/SQL program directly into any text file without showing it in the oracle screen , HOW CAN I DO THAT ????
Thanks,
Udit.