Urgent !!!!!!!!!! Urgent

From: Syed Faisal Shah <faisal_at_cyber.net.pk>
Date: 1998/04/25
Message-ID: <3541EB77.D24AAB7F@cyber.net.pk>#1/1

Help Needed

We have prepared a PL/SQL procedure in which we call 1343 records in cursor. The data that comes into the cursor in is numeric and we are deleting records from another table on the basis of value fetched from cusor.

After deleting 48 records, it gives the following error.

ORA - 20000 ORU-10027 Buffer overflow, exceed 2000 bytes limit.

Please reply if anyone could help.

--


------------------------------------------------------------------------------------------


                                Syed Faisal Shah
                                Systems Engineer
                     Cyber Internet Services (Pvt.) Limited
                     A-904, Lakson Square Building No. 3,
                             Sarwar Shaheed Road,
                                Karachi - 74200
                                   Pakistan
Phone...: +92 21 111 44 55 66
Fax.....: +92 21 5686745
E-Mail..: faisal_at_cyber.net.pk
URL.....: http://www.cyber.net.pk


------------------------------------------------------------------------------------------

Received on Sat Apr 25 1998 - 00:00:00 CDT