Re: Another SQLcl quirk

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Jeff Smith <jeff.d.smith@xxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 12 Jul 2019 11:07:12 -0400

Thanks Jeff!

You are great, not to mention the product.

Regards

On 7/12/19 10:47 AM, Jeff Smith wrote:


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@xxxxxxxxx>
*Sent:* Friday, July 12, 2019 10:40 AM
*To:* oracle-l@xxxxxxxxxxxxx
*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?

Other related posts: