Re: Problem with a procedure
Date: Wed, 09 Apr 2008 13:32:43 +0200
>>> 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 upReceived on Wed Apr 09 2008 - 06:32:43 CDT