Hi SQL CL Development Team,
In SQL*Plus the following works as expected:
SQL*Plus: Release 12.1.0.2.0 Production on Mon Dec 10 14:25:21 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Mon Dec 10 2018 14:11:07 -05:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> variable v clob
SQL> exec :v := 'abc'
PL/SQL procedure successfully completed.
SQL> set heading off
SQL> print v
abc
but in SQL CL the PRINT output contains a column heading and separator even though SET HEADING OFF was used.
SQLcl: Release 18.3 Production on Mon Dec 10 14:11:03 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing
SQL> variable v clob
SQL> exec :v := 'abc'
PL/SQL procedure successfully completed.
SQL> set heading off
SQL> print v
V
--------------------------------------------------------------------------------
abc
If you don't already know about this bug please log it.
Thanks.
(SQL CL was running on Windows 10 via Powershell for this test)