Forum Stats

  • 3,874,451 Users
  • 2,266,734 Discussions
  • 7,911,852 Comments

Discussions

"BREAK ON" seems broken in SQLcl binary and API

user2530729
user2530729 Member Posts: 9 Blue Ribbon

"BREAK ON" seems to be broken in SQLcl binary and API

Something to do with CHAR() types in some situations but not others?

(Works properly in SQLPlus)

  1. See attached test SQL: breaktest.sql
  2. Run in SQLPlus and SQLcl (binary) against same schema
  3. Compare outputs: output_sqlcl.txt vs output_sqlplus.txt
  4. My environment: JDK 1.8.0_291, SQLcl 21.1.1, SQL*Plus: Release 12.2.0.1.0 Production

Any suggestions?

Thanks!

Bob

P.S. Also posted here, but no responses yet: https://github.com/oracle/oracle-db-tools/issues/37

Best Answer

Answers