Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PRINT command does not respect "set heading off"

J. Fuda-OracleDec 10 2018

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)

Comments

Post Details

Added on Dec 10 2018
0 comments
311 views