I am using sqlcl-184.108.40.2060.1251 and 19C.
I performed the standard command of exporting the DB objects and it was created as expected.
lb genschema -split.
While trying to upload the objects it errored out for few objects mostly PLSQL oriented like packages and triggers and not for all packages and triggers.
CREATE OR REPLACE EDITIONABLE TRIGGER TEST_PUBLIC_HOLIDAYS_TRIGG" BEFORE INSERT ON TEST_PUBLIC_HOLIDAYS
FOR EACH ROW
IF INSERTING AND :NEW.ID IS NULL
SELECT TEST_PUBLIC_HOLIDAYS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
ALTER TRIGGER TEST_PUBLIC_HOLIDAYS_TRIGG" ENABLE
This has a / back slash after the trigger and therefore didn't failed when executing via schema user.
CREATE OR REPLACE EDITIONABLE TRIGGER TEST_EMAILS_LIST_TRG" before
insert ON TEST_EMAILS_LIST for each row
if :new.id is null then
:new.id := TEST_EMAILS_LIST_SEQ.nextval;
ALTER TRIGGER TEST_EMAILS_LIST_TRG" ENABLE
Where the backslash wasn't created.
Both the scripts were created by Liquibase only and of course I have extracted the SQL from the .XML files.
I am failing to understand the reason why two differenst scripts were generated by tool and how can we ensure the backslash is always populated to avoid getting 4/1 PLS-00103: Encountered the symbol "ALTER"