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!

SQLcl Projects 25.3.0 ignores emitSchema false for DBMS_SCHEDULER calls

Description:
When exporting DBMS_SCHEDULER objects, including create_job, set_attribute, and enable calls, SQLcl projects emits schema-qualified object names even if emitSchema: false is set in the project configuration.

Example affected calls:

  • dbms_scheduler.create_job
  • dbms_scheduler.set_attribute
  • dbms_scheduler.enable

Expected behavior:
When emitSchema: false is enabled, SQLcl should generate DBMS_SCHEDULER statements without explicit schema names, using just the object name.

This post has been answered by danmcghan-Oracle on Oct 17 2025
Jump to Answer
Comments
Post Details
Added on Oct 17 2025
3 comments
62 views