RE: Another SQLcl quirk

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Fri, 12 Jul 2019 07:47:52 -0700 (PDT)
Message-ID: <206c9409-70bf-4f15-bb5d-20aa60e146b7_at_default>

Appears to be

 

SQL> show version

Oracle SQLDeveloper Command-Line (SQLcl) version: 19.2.0.0

SQL> set history fails

SQL> show history

HISTORY         enabled

        blacklist: show,history,connect,set

        Show failed statements:(20 statements)

SQL> select 1 form dual;

 

Error starting at line : 1 in command -

select 1 form dual

Error at Command Line : 1 Column : 15

Error report -

SQL Error: ORA-00923: FROM keyword not found where expected

00923. 00000 -  "FROM keyword not found where expected"

*Cause:

*Action:

Elapsed: 00:00:00.387

SQL> history

History:

  1  lb help genobjecet

  2  lb help genobject

  3  cd c:\SQLDev\sqlcl\192-final\sqlcl\lb\rest-demo\v1

  4  desc locations

  5  info locations

  6  info+ locations

  7  select * employees;

  …

49  select * from regions;

50  select 1 form dual;

SQL>  

From: Mladen Gogala <gogala.mladen_at_gmail.com> Sent: Friday, July 12, 2019 10:40 AM
To: oracle-l_at_freelists.org
Subject: Another SQLcl quirk

 

I can't get it to show failed lines:

SQL> set history limit 50 fails
SQL> show history
HISTORY

        enabled
        blacklist: show,history,connect,set
        Do not show failed statements
        Max Size: 50

SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version: 19.1.0.0 SQL> This looks like a bug. Will it be fixed in the next release, which is due in a couple of days?

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

Received on Fri Jul 12 2019 - 16:47:52 CEST