mowinom@[EMAIL PROTECTED]
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 dip****; 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
|
