Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

DDL Unable to save package body to file

user4069254Feb 19 2024

Hi,

I'm unable to save a package body to file with the ddl command. I think this is caused by the whitespace in “package body”. How can i save a package body to file?

ddl test_api package body save test.sql      -- 'test.sql' at column 31: Unexpected token
ddl test_api package body                    -- No file name specified for SAVE option.
ddl test_api "package body"                  -- Runs ok
ddl test_api "package body" save test.sql    -- DDL command line parse error
  • Oracle SQLDeveloper Command-Line (SQLcl) version: 23.4.0.0 build: 23.4.0.023.2321
  • Oracle Linux Server 7.9
  • openjdk 14.0.2

When i run the command ddl test_api package body save test.sql in a sqlcl terminal in VS Code on Windows it runs without any problems.

This post has been answered by user9540031 on Feb 19 2024
Jump to Answer
Comments
Post Details
Added on Feb 19 2024
2 comments
148 views