PL/SQL buffer error

 Hello everyone, I wrote this pl/sql prog. that has some 6 cursors and 2 loops. One loop is an implicit loop used to go through every record and so it spans from the beginning of the program till the end. The other loop is a small loop that goes through a varchar2 field and parses it one by one looking for numbers. The length of this varchar2 field is 25, however, my program only handled two records with a max value of 16 in this field. I commit before the end loop statement. I get the following error. Your help is greatly appreicated (deadline is 2 days from now).

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes ORA-06512: at line 512

Thank you.
Afshin.

--
Please visit the following site to get to know the real Sathya Sai Baba: http://www.myfreeoffice.com/saibabaexposed/index.html

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 21 1999 - 18:15:50 CDT