Re: Another SQLcl quirk

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_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