René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes","articleBody":"**Describe the bug**\r\nI started yesterday with writing unittests using utPLSQL. Yesterday, everything worked fine but starting this afternoon I cannot use the sqldeveloper plugin to create coverage reports anymore(test run still works).\r\n\r\nExecuting the script results in:\r\n```\r\nEXECUTE dbms_session.reset_package;\r\nSET SERVEROUTPUT ON SIZE UNLIMITED\r\nCLEAR SCREEN\r\nEXEC ut.run('[redacted]',ut_coverage_html_reporter())\r\n```\r\n\r\n\u003e Fehler beim Start in Zeile: 4 in Befehl -\r\n\u003e BEGIN ut.run('[redacted]',ut_coverage_html_reporter()); END;\r\n\u003e Fehlerbericht -\r\n\u003e ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes\r\n\u003e ORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 32\r\n\u003e ORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 97\r\n\u003e ORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 112\r\n\u003e ORA-06512: in \"UNITTESTS.UT_OUTPUT_BUFFER_BASE\", Zeile 59\r\n\u003e ORA-06512: in \"UNITTESTS.UT_OUTPUT_REPORTER_BASE\", Zeile 80\r\n\u003e ORA-06512: in \"UNITTESTS.UT\", Zeile 504\r\n\u003e ORA-06512: in \"UNITTESTS.UT\", Zeile 623\r\n\u003e ORA-06512: in Zeile 1\r\n\u003e 20000. 00000 -  \"%s\"\r\n\u003e *Cause:    The stored procedure 'raise_application_error'\r\n\u003e            was called which causes this error to be generated.\r\n\u003e *Action:   Correct the problem as described in the error message or contact\r\n\u003e            the application administrator or DBA for more information.\r\n\r\nUsing the sqldeveloper menu entry the logging of sqldeveloper shows this log after a while:\r\nError when running code coverage: StatementCallback; uncategorized SQLException for SQL [BEGIN\r\n\tut.run(\r\n\t\ta_paths =\u003e ut_varchar2_list(\r\n\t\t\t'[redacted]'\r\n\t\t),\r\n\t\ta_reporter =\u003e ut_coverage_html_reporter()\r\n\t);\r\nEND;\r\n]; SQL state [72000]; error code [20000]; ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes\r\nORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 32\r\nORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 97\r\nORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 112\r\nORA-06512: in \"UNITTESTS.UT_OUTPUT_BUFFER_BASE\", Zeile 59\r\nORA-06512: in \"UNITTESTS.UT_OUTPUT_REPORTER_BASE\", Zeile 80\r\nORA-06512: in \"UNITTESTS.UT\", Zeile 504\r\nORA-06512: in Zeile 2\r\n; nested exception is java.sql.SQLException: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes\r\nORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 32\r\nORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 97\r\nORA-06512: in \"SYS.DBMS_OUTPUT\", Zeile 112\r\nORA-06512: in \"UNITTESTS.UT_OUTPUT_BUFFER_BASE\", Zeile 59\r\nORA-06512: in \"UNITTESTS.UT_OUTPUT_REPORTER_BASE\", Zeile 80\r\nORA-06512: in \"UNITTESTS.UT\", Zeile 504\r\nORA-06512: in Zeile 2\r\n\r\n\r\n**Provide version info**\r\nInformation about utPLSQL and Database version, \r\n12.1.0.2.0\r\n12.1.0.2.0\r\n\r\nPL/SQL-Prozedur erfolgreich abgeschlossen.\r\n\r\nUT_VERSION                                                  \r\n------------------------------------------------------------\r\nv3.1.10.3349\r\n\r\n\r\nBANNER                                                                               CON_ID\r\n-------------------------------------------------------------------------------- ----------\r\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production              0\r\nPL/SQL Release 12.1.0.2.0 - Production                                                    0\r\nCORE\t12.1.0.2.0\tProduction                                                                  0\r\nTNS for Linux: Version 12.1.0.2.0 - Production                                            0\r\nNLSRTL Version 12.1.0.2.0 - Production                                                    0\r\n\r\n\r\nPARAMETER                                                                                                                VALUE                                                                                                                                                                                                                                                           \r\n-------------------------------------------------------------------------------------------------------------\r\nNLS_LANGUAGE                                                                                                             GERMAN                                                                                                                                                                                                                                                          \r\nNLS_TERRITORY                                                                                                            GERMANY                                                                                                                                                                                                                                                         \r\nNLS_CURRENCY                                                                                                             ?                                                                                                                                                                                                                                                               \r\nNLS_ISO_CURRENCY                                                                                                         GERMANY                                                                                                                                                                                                                                                         \r\nNLS_NUMERIC_CHARACTERS                                                                                                   ,.                                                                                                                                                                                                                                                              \r\nNLS_CALENDAR                                                                                                             GREGORIAN                                                                                                                                                                                                                                                       \r\nNLS_DATE_FORMAT                                                                                                          DD.MM.RR HH24:MI:SS                                                                                                                                                                                                                                             \r\nNLS_DATE_LANGUAGE                                                                                                        GERMAN                                                                                                                                                                                                                                                          \r\nNLS_SORT                                                                                                                 GERMAN                                                                                                                                                                                                                                                          \r\nNLS_TIME_FORMAT                                                                                                          HH24:MI:SSXFF                                                                                                                                                                                                                                                   \r\nNLS_TIMESTAMP_FORMAT                                                                                                     DD.MM.RR HH24:MI:SSXFF                                                                                                                                                                                                                                          \r\n\r\nPARAMETER                                                                                                                VALUE                                                                                                                                                                                                                                                           \r\n--------------------------------------------------------------------------------------------------------------\r\nNLS_TIME_TZ_FORMAT                                                                                                       HH24:MI:SSXFF TZR                                                                                                                                                                                                                                               \r\nNLS_TIMESTAMP_TZ_FORMAT                                                                                                  DD.MM.RR HH24:MI:SSXFF TZR                                                                                                                                                                                                                                      \r\nNLS_DUAL_CURRENCY                                                                                                        ?                                                                                                                                                                                                                                                               \r\nNLS_COMP                                                                                                                 BINARY                                                                                                                                                                                                                                                          \r\nNLS_LENGTH_SEMANTICS                                                                                                     CHAR                                                                                                                                                                                                                                                            \r\nNLS_NCHAR_CONV_EXCP                                                                                                      FALSE                                                                                                                                                                                                                                                           \r\n\r\n17 Zeilen gewählt. \r\n\r\n\r\nPORT_STRING                                                 \r\n------------------------------------------------------------\r\nx86_64/Linux 2.4.xx\r\n\r\n\r\n**Information about client software**\r\nSQLDeveloper with installed utPlsql plugin\r\n\r\n**Expected behavior**\r\nI would expect that this call works and creates the coverage report.\r\n","author":{"url":"https://github.com/wolframhaussig","@type":"Person","name":"wolframhaussig"},"datePublished":"2020-03-12T12:53:24.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":10},"url":"https://github.com/93/utPLSQL-SQLDeveloper/issues/93"}