SQLCL Spool Output Not Contain SQL Statements
(Doc ID 2916078.1)
Last updated on DECEMBER 16, 2022
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 |