DBMS_OUTPUT Output Gets Truncated when Using ARRAYSIZE in SQLPLUS 12.2.0.1

(Doc ID 2335921.1)

Last updated on DECEMBER 07, 2017

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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms