Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLcl 4.2 - Issues with sql*plus set options and column formating

Gunther PippèrrMay 2 2016 — edited May 18 2016

Hello Team,

a very good idea to create a new sql command interpreter.

I use  the version sqlcl-4.2.0.16.112.0616-no-jre.zip (fresh download from today).

Fist I  have under Linux and Windows in the beginning some trouble with the call scripts, the usage of JAVA_HOME is not really completely implemented. 

I have to fix all java calls to a full qualified path with variables, on hosted System you often have no installed java and no java in the path!

Also I test my daily scripts, written over the last year and I get a lot of errors like this:

SQL> column status    format A8  heading "Status"

SQL> column name      format A8  heading "Instance|Name"

SQL> column startzeit format A15 heading "Start|Time"

SQL> column host_name format A35 heading "Server|Name"

SQL> select  status  , instance_name as name   , to_char(STARTUP_TIME, 'dd.mm.YY hh24:mi') as startzeit , host_name   from v$instance order by 1;

Mai 02, 2016 2:24:00 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run

SCHWERWIEGEND: java.util.Formatter$FormatSpecifier.checkGeneral(Formatter.java:2954)

java.util.MissingFormatWidthException: %-01$s

        at java.util.Formatter$FormatSpecifier.checkGeneral(Formatter.java:2954)

        at java.util.Formatter$FormatSpecifier.<init>(Formatter.java:2725)

        at java.util.Formatter.parse(Formatter.java:2560)

        at java.util.Formatter.format(Formatter.java:2501)

        at java.util.Formatter.format(Formatter.java:2455)

        at java.lang.String.format(String.java:2928)

And are all set Options implemented?

I get errors with this Options:

SQL> set recsep off

SP2-0158: Unbekannte SET-Option "recsep"

SQL> SET UNDERLINE '='

SP2-0158: Unbekannte SET-Option "underline"

SQL> column mb_total format 999G999G999D00 heading "MegaByte |Total used on disk"

SP2-0246: Ung├╝ltige FORMAT-Zeichenfolge "999G999G999D00"

SQL> column host_name format A18 heading "Inst Server|Name"

SQL> column edition   like host_name  heading "DB|Version"

SP2-0158: Unbekannte COLUMN-Option "like"

All my scripts as test examples you can find here https://orapowershell.codeplex.com/SourceControl/latest#sql/database.sql

Also you should try this script, it crashes the SQLcl completely .-) => https://orapowershell.codeplex.com/SourceControl/latest#sql/login.sql

Thanks

Best Regards

Gunther



Comments

Post Details

Added on May 2 2016
9 comments
6,631 views