Forum Stats

  • 3,734,173 Users
  • 2,246,901 Discussions
  • 7,857,155 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)

Sign In or Register to comment.