SQLCL Spool Output Not Contain SQL Statements (Doc ID 2916078.1)

Last updated on DECEMBER 16, 2022

Applies to:

Symptoms

On : 22.2.1 version, SQLcl/SQL*Plus Commands

Comparing the SQLlcl spool output against the SQL*Plus spool output shows that the SQL statements are not added in SQLcl tool.

Test Case

=======
1. Use SQLcl to connect to database and execute these commands
SQL> spool <DRIVE>\sqlcl_222.txt
SQL> select 1 from dual;

1
____
1

SQL> spool off

2. SQLcl spool output is showing like this:

1
____
1

3. Perform the same steps in SQL*Plus and compare the output. SQL*Plus spool
output contain both select statement and 'spool off'.

SQL*Plus spool output
--------------------
SQL> select 1 from dual;

1
____
1

SQL> spool off

Attaching the customer testcase for reference.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.