Hello all,
I found one problem with Liquibase when trying to execute a procedure/package.
Here is the file annotation:
–liquibase formatted sql
–changeset unknown:falcon.change_processor runOnChange:true
CREATE OR REPLACE
PROCEDURE falcon.change_processor
When I change the file and try to execute it, the change does not apply into my database. I managed to “fix” it by changing the schema name of the procedure to uppercase
–liquibase formatted sql
–changeset unknown:falcon.change_processor runOnChange:true
CREATE OR REPLACE
PROCEDURE FALCON.change_processor
In case that the changeset has the schema with uppercase then the schema of the procedure must be with lowercase.
Could you please let me know if you experience the same issue and if this is an expected behavior?