Skip to Main Content

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!

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
101 views