In Oracle 9.2.0.6, running the SQL statement directly is ok. When running the same SQL statement with DBMS buffers set to max., DBMS_Debug off, and DBMS_OUTPUT off Toad gives the following errors:
ORA-20000 ORU-10027 buffer overflow, limit of 1000000 bytes.
ORA-06512 at SYS.DBMS_OUTPUT, line 35
This worked fine under earlier versions of TOAD but v9.0.1.8 is gives a buffer overflow errors as above.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center