RE: SQLCl: problems with describe are back

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Wed, 19 Feb 2020 10:59:24 -0800 (PST)
Message-ID: <cdcd8c02-eda8-4f4d-b6f3-c7379681fd8a_at_default>

Thanks for the note, I'll get this logged and fixed.

Jeff

-----Original Message-----

From: Mladen Gogala <gogala.mladen_at_gmail.com> Sent: Tuesday, February 18, 2020 11:30 AM To: oracle-l_at_freelists.org
Subject: SQLCl: problems with describe are back

I installed the latest and the greatest SQLCl, namely 19.4. I tried describing V$SYSTEM_EVEN but it didn't work. The dump is below. Interestingly enough, this only happens on Windows. Linux version works fine.

SQLcl: Release 19.4 Production on Tue Feb 18 11:18:15 2020

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Last Successful login time: Tue Feb 18 2020 11:18:16 -05:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

login.sql found in the CWD. DB access is restricted for login.sql. Adjust the SQLPATH to include the path to enable full functionality. SQL>
SQL> set timing on

SQL> desc v$system_event
Feb 18, 2020 11:18:41 AM
oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run SEVERE: java.util.regex.Matcher.appendReplacement(Unknown Source) java.lang.IllegalArgumentException: Illegal group reference

         at java.util.regex.Matcher.appendReplacement(Unknown Source)
         at java.util.regex.Matcher.replaceAll(Unknown Source)
         at java.lang.String.replaceAll(Unknown Source)
         at

oracle.dbtools.raptor.newscriptrunner.commands.DescribePrep.compileViewIfRequired(DescribePrep.java:1391)          at
oracle.dbtools.raptor.newscriptrunner.commands.DescribePrep.parseDescribe(DescribePrep.java:294)          at
oracle.dbtools.raptor.newscriptrunner.commands.DescribePrep.handleEvent(DescribePrep.java:79)          at
oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:334)          at
oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:226)          at
oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:344)          at
oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:227)          at
oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:407)          at
oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:418)          at
oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1252)          at
oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:494)

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

--

https://urldefense.com/v3/__http://www.freelists.org/webpage/oracle-l__;!!GqivPVa7Brio!OuS9llSOaqKLY3577l3EGkVB1uNgoFm7Hxc3y4wMfGThuUzVH5DGW-2sj9MebrI1YxQ$

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 19 2020 - 19:59:24 CET