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 lb exit code is always 0

Ned GhanemMar 3 2022

Hi
I am running sqlcl liquibase from script like so.
The exit code is always 0 regardless of success or failure of change log errors .
How can we get return code when sqlcl lb fail?
sql /nolog<<EOF
WHENEVER OSERROR EXIT FAILURE
WHENEVER SQLERROR EXIT FAILURE
connect usr/pwd
lb update -changelog changelog.xml
EOF
echo $?

Comments
Post Details
Added on Mar 3 2022
3 comments
515 views