Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Urgent !!!!!!!!!! Urgent
>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.
Are you using dbms_output ? if so, enlarge the buffer (dbms_output.enable (a large number of bytes))
Ronald