Re: Problem with a procedure

From: Frank van Bortel <>
Date: Wed, 09 Apr 2008 13:32:43 +0200
Message-ID: <3ef12$47fca95c$524b5c40$> wrote:

>>> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
>>> ORA-06512: at "SYS.DBMS_OUTPUT", line 32
>>> ORA-06512: at "SYS.DBMS_OUTPUT", line 97
>>> ORA-06512: at "SYS.DBMS_OUTPUT", line 112
>>> ORA-06512: at "P_ADD_VPD_34", line 16
>>> ORA-06512: at line 1

> However, I this example that was not the main problem (a derived
> problem may be) because the bigger table has only 51 records in it.

Listen you little dipshit; David is 100% correct in his answer - just READ the darn error - it's all about dbms_output. And that is all you posted about. So don't reply that it "might be a derived problem". It's not.

The fact that you have "only" 51 records in it shows how little you understand of what you have crafted: for *every* entry in USER_POLICIES you print out *every* entry in vpd_tabell_v - if all entries in vpd_tabell_v is less than 40 byte, you're correct. However, I find that unlikely, but I have only been in the trade for 25 years or so, so I may be wrong. I've been wrong before.


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Wed Apr 09 2008 - 06:32:43 CDT

Original text of this message