Re: Problem with a procedure

mowinom_at_hotmail.com 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.

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up