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 Projects: failed to format

Plamen Petrov4 days ago

Hi,

I am trying out the SQLcl Projects feature. Started by creating a project and exporting my existing schema:

SQL> version
Oracle SQLDeveloper Command-Line (SQLcl) version: 26.1.2.0 build: 26.1.2.132.1334
SQL> project export -debug -verbose
....
Errors:
============================================================
PACKAGE_BODY  PP_1.APP_1_PKG: Failed to format, syntax error
PACKAGE_BODY  PP_1.CO_2_PKG: Failed to format, syntax error
============================================================
--------------------------------
COMMENT                       35
....

This is a schema of a fully-functional application, there are no any errors! Oracle is 23.26.2 Enterprise. Most packages make substantial use of 23ai SQL features. How to debug/fix this? Formatting of the exported code is essential.

Added 4 days ago

2 comments

40 views

1 mention