Skip to Main Content

SQL Developer

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!

Final semicolon vanishes in CREATE PACKAGE BODY from file

Kai QualeNov 14 2025

We are experiencing a weird problem where SQLcl (in conjunction with Liquibase) removes the semicolon in the final END statement:

CREATE OR REPLACE PACKAGE BODY <package name>
...
END <package name>;
/

The result is this, which of course doesn't compile:

CREATE OR REPLACE PACKAGE BODY <package name>
...
END <package name>
/

The statement is done via the @filename notation.

It only happens with this particular file. It's UTF-8 encoded (like all our files) and doesn't contain anything weird (like control characters) at the end.

We are running SQLcl 25.3 (I don't have more version details) as part of a GitLab pipeline.

I'm not sure if it's a SQLcl problem or a Liquibase problem, but I have to start somewhere…

Comments
Post Details
Added on Nov 14 2025
2 comments
52 views