Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"BREAK ON" seems broken in SQLcl binary and API

user2530729Jun 29 2021

github_issue37_20210623.zip (4.49 KB)"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)
See attached test SQL: breaktest.sql
Run in SQLPlus and SQLcl (binary) against same schema
Compare outputs: output_sqlcl.txt vs output_sqlplus.txt
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

This post has been answered by user2530729 on Jul 2 2021
Jump to Answer

Comments

Post Details

Added on Jun 29 2021
1 comment
144 views