Re: SQLCl: problems with describe are back

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 19 Feb 2020 20:00:31 -0500
Message-ID: <8dfab54e-3c4f-0cb9-b3ad-7cb5fb3afaa8_at_gmail.com>

Hi Jeff!

You spoiled me with this marvelous tool. However, I made a mistake. Since this is 12.2 database, which comes with SQLCl preinstalled, I used the wrong version. The original version, shipped with 12.2 on Linux does not have  a problem with describe. Version 19.4 unfortunately still does have a problem:

SQLcl: Release 19.4 Production on Wed Feb 19 19:53:33 2020

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

Last Successful login time: Wed Feb 19 2020 19:53:33 -05:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.6.0.0.0

SQL> desc v$system_event;
Feb 19, 2020 7:53:46 PM
oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run SEVERE: java.util.regex.Matcher.appendReplacement(Matcher.java:857) java.lang.IllegalArgumentException: Illegal group reference

     at java.util.regex.Matcher.appendReplacement(Matcher.java:857)
     at java.util.regex.Matcher.replaceAll(Matcher.java:955)
     at java.lang.String.replaceAll(String.java:2223)
     at 

oracle.dbtools.raptor.newscriptrunner.commands.DescribePrep.compileViewIfRequired(DescribePrep.java:1391)

Interestingly enough, the exception doesn't break the connection.

Regards

On 2/19/20 1:59 PM, Jeff Smith wrote:
> Thanks for the note, I'll get this logged and fixed.
>
> Jeff

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 20 2020 - 02:00:31 CET