Oracle DB 19c
Hello Team,
could you please advise on error below?
Compilation is working fine.
create or replace trigger "UPDATE_MCBAPPROVAL_FOR_LIMITS"
after insert
on approvable_limit
for each row
declare
serviceagreementnamevar varchar2(50);
legalentitynamevar varchar2(50);
legalentityexternalidvar varchar2(50);
serviceagreementidvar varchar2(50);
begin
select service_agreement.name as service_agreement_name
, legal_entity.name as legal_entity_name
, legal_entity.external_id as legal_entity_id
, service_agreement.id as service_agreement_id
into serviceagreementnamevar
, legalentitynamevar
, legalentityexternalidvar
, serviceagreementidvar
from user_pandp.en_user customer_user_detail
inner join accesscontrol_pandp.legal_entity legal_entity
on legal_entity.id = customer_user_detail.legal_entity_id
inner join accesscontrol_pandp.service_agreement service_agreement
on service_agreement.id = :new.eref_0
where :new.user_id = customer_user_detail.id;
update approval_persistence.mcb_approval
set service_agreement_name = serviceagreementnamevar
, legal_entity_name = legalentitynamevar
, legal_entity_id = legalentityexternalidvar
, service_agreement_id = serviceagreementidvar
where id = :new.approval_id;
exception
when no_data_found then
dbms_output.put_line('No Record');
end;