Forum Stats

  • 3,757,175 Users
  • 2,251,204 Discussions
  • 7,869,751 Comments

Discussions

PRINT command does not respect "set heading off"

J. Fuda-Oracle
J. Fuda-Oracle Member Posts: 116 Employee

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 2018Copyright (c) 1982, 2014, Oracle.  All rights reserved.Last Successful login time: Mon Dec 10 2018 14:11:07 -05:00Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing optionsSQL> variable v clobSQL> exec :v := 'abc'PL/SQL procedure successfully completed.SQL> set heading offSQL> print vabc

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 2018Copyright (c) 1982, 2018, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,OLAP, Advanced Analytics, Oracle Database Vault and Real Application TestingSQL> variable v clobSQL> exec :v := 'abc'PL/SQL procedure successfully completed.SQL> set heading offSQL> print vV--------------------------------------------------------------------------------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)