Skip to Main Content

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
5,587 views