Hello,
I have the following trigger which compiles in VS Code or SQL Developer or SQLcl. When I try to deploy using project deploy I am getting the error below. Has anybody experienced this? Thanks
Error
Reason: liquibase.exception.DatabaseException: ORA-00900: invalid SQL statement
https://docs.oracle.com/error-help/db/ora-00900/ [Failed SQL: (900) :new.updated := localtimestamp]
ORA-00900: invalid SQL statement
Trigger
create or replace editionable trigger app_group_biu before
insert or update on app_group
for each row
begin
if inserting then
:new.created := localtimestamp;
:new.created_by := coalesce(
sys_context('APEX$SESSION', 'APP_USER'),
user
);
end if;
:new.updated := localtimestamp;
:new.updated_by := coalesce(
sys_context('APEX$SESSION', 'APP_USER'),
user
);
end app_group_biu;
/
alter trigger app_group_biu enable;