Skip to Main Content
Forums

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!

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

thatJeffSmith-Oracle

not to take you too far off track, but to ask ords to run the same queries using the same db_links would be trivial

Vanja Keglević

Jeff,

we're migrating from db links to ORDS because of the SCN problem with Oracle dbs.

So we cannot anymore use db links from an Oracle 11g XE to Oracle 11g Standard db, that is our problem.

Kind regards

1 - 2

Post Details

Added on May 2 2016
9 comments
6,814 views