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!

Missing linebreak after deployment

Thomas SJan 21 2022

Hi there,
I have the following problem since version 21.X. I have a procedure / function which I export with XY.
Procedure:
image.pngIf I export and import this with a SQLCL version 21.x, the last line is always shifted directly behind the previous one.
-> Version sqlcl_21.4.1
lb genschema -grants
File:
image.pnglb update -changelog controller.xml
Result on the Database:
image.png
In this case it is ugly but valid.
But what about types?
image.pngimage.pngimage.pngThe object becomes invalid.
The problem did not exist in older versions. So I'm assuming it's a bug and I hope it gets fixed.

best regards
Thomas

Comments

Thomas S

/push

Recently we logged it as "Bug 34449082 : SECOND LB GENSCHEMA COMMAND IN SINGLE SQLCL SESSION BREAKS XML FILE & ADDS /"
Follow this bug to avail the fix.
Thanks, Suresh

Thomas S

Thanks for you Reply Suresh.
I don't know if I'm interpreting this correctly, but the problem doesn't arise with "gene schema". It occurs with the "lb update" command. The XML files look ok.

1 - 3

Post Details

Added on Jan 21 2022
3 comments
133 views