My Oracle Support Banner

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

Last updated on AUGUST 08, 2023

Applies to:

Oracle SQLcl - Version 22.2.1 to 22.3.1 [Release 22]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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