DBMS_OUTPUT Output Gets Truncated when Using ARRAYSIZE in SQLPLUS 12.2.0.1
(Doc ID 2335921.1)
Last updated on MARCH 03, 2025
Applies to:
SQL*Plus - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]Information in this document applies to any platform.
Symptoms
DBMS_OUTPUT.PUT_LINE() does not produce the expected output, it gets truncated, when using ARRAYSIZE.
Example (The below example should have 1188 lines of DBMS_OUTPUT.PUT_LINE(1);)
SET ARRAY 1000;
SET SERVEROUT ON;
SPO "test-plus-&_SQLPLUS_RELEASE.-on-rdbms-&_O_RELEASE..txt"
BEGIN
DBMS_OUTPUT.PUT_LINE(1);
DBMS_OUTPUT.PUT_LINE(1);
DBMS_OUTPUT.PUT_LINE(1);
DBMS_OUTPUT.PUT_LINE(1);
DBMS_OUTPUT.PUT_LINE(1);
DBMS_OUTPUT.PUT_LINE(1);
.
.
DBMS_OUTPUT.PUT_LINE(1);
END;
/
SPO off
The spool file created only shows 1000 lines.
The same script works fine in 12.1.0.2 and 11.2.0.4 and shows 1188 lines.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |