Skip to Main Content
Forums

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

24.4.1 Unexpected Schema Name in Drop Script despite emitSchema: false

Description:
I encountered an issue where SQLcl unexpectedly includes the schema name in the generated drop script, even though emitSchema is set to false in project.config.json.

Steps to Reproduce:

  1. Dropped a package in the database.
  2. Deleted the corresponding package file from the src folder.
  3. Staged the changes using project stage.
  4. SQLcl generated a drop script that includes the schema name.

Expected Behavior:
Since emitSchema is set to false, the drop script should not contain the schema name, consistent with how SQLcl has handled all other objects in my project.

Actual Behavior:
The generated drop script contains the schema name, which is inconsistent with previous behavior.

Question:
Could you take a look at this? Is this an expected behavior, or is it a bug?

Thank you
Patrizia
This post has been answered by danmcghan-Oracle on Feb 25 2025
Jump to Answer

Comments

Post Details

Added on Feb 22 2025
1 comment
57 views