Skip to Main Content
Forums

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLCL format command error

Arnost KlaskaApr 7 2018 — edited Apr 11 2018

Hi,

downloaded new version of SQLDeveloper 18.1. Trying to format sql file with SQLDeveloper format settings but Failed to read custom formatting program error reported:

klaska@n0515:~/HCI_projects/Cart$ /opt/sqldeveloper/sqldeveloper/bin/sql /nolog

SQLcl: Release 18.1 Production on Sat Apr 07 19:48:27 2018

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

SQL> format rules formater.xml

Formatter rules loaded

SQL> format file TABLES.sql TABS.sql

Failed to read custom formatting program /home/klaska/.sqldeveloper/system18.1.0.095.1630/o.sqldeveloper/format.arbori

/home/klaska/.sqldeveloper/system18.1.0.095.1630/o.sqldeveloper/format.arbori (No such file or directory)

Found this file in old version directory only

SQL> klaska@n0515:~/HCI_projects/Cart$ find ~/.sqldeveloper/ -type f -name format.arbori

/home/klaska/.sqldeveloper/system17.4.1.054.0712/o.sqldeveloper/format.arbori

Any clues?
This post has been answered by thatJeffSmith-Oracle on Apr 10 2018
Jump to Answer

Comments

Processing

Post Details

Added on Apr 7 2018
4 comments
614 views