On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,626 Users
  • 2,269,768 Discussions
  • 7,916,798 Comments

Discussions

Random Ansi symbols in output text file

User_QSVY3
User_QSVY3 Member Posts: 1 Blue Ribbon
edited Aug 14, 2020 7:55AM in SQLcl
I have my output to  SET SQLFORMAT default
I am calling sqlcl from ant, I am just wondering if someone has seen these random ansi symbols.


'bobotest5.sql'
     [exec]  [m



[exec]  [2K
  [exec] SQL>  [mDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  [exec] Version 19.7.0.0.0

Answers

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,785 Bronze Crown
    edited Aug 14, 2020 7:55AM

    What are the "random symbols" you are talking about?

    Please provide a SMALL repeatable example of exactly what you are doing so others can attempt to replicate the behavior you are seeing.

    Also povide sqlcl version.

    What does "bototest5.sql" contain?

    What is the OS you are using?

    It appears from the mininal information you have posted, it is badly formatted or badly interpreted definitions of control characters or control character usage.