Hello, Its version 19C of oracle. We are seeing below error message in one of the log table in production and were trying to find the root cause of the error and fix it. The error logging has happened in below way. The obvious suspect was, if we are using dbms_output in our source code and that is causing the default limit of the dbms_output buffer to get exceeded and thus errored out, but we didn't find any ‘%dbms_output%’ text used in our current procedure or anywhere in the source code in dba_source. So wanted to understand what else could be the reason of this error and how to fix it?
ORU-10027: buffer overflow, limit of 20000 bytes
EXCEPTION
WHEN OTHERS THEN
v_error := sqlerrm;
INSERT INTO log_table ( ....... ) values ( .....);