Hola chicos,una consulta estoy haciendo un trigger que quiero que me actulice otra table pero me sale este error ora-04091
el trigger es el siguiente
CREATE OR REPLACE TRIGGER "EMERALD"."TRG_INSERT_ARDUHIS" AFTER
INSERT ON "AR_DOCUMENT" FOR EACH ROW DECLARE
v_flag varchar2(1);
BEGIN
SELECT flagregventa
INTO v_flag
FROM erp_documenttype
where documenttype=:new.documenttype and company=:new.company ;
---- SI EL FLAG ES DIFERENTE DE Y ENTONCES ES CANJE O FINANCIAMIENTO -----
if v_flag <> 'Y' then
insert into AR_DOCUMENTHISTORY (DOCUMENTPRINCIPAL,
DOCUMENTCHILD,
DOCUMENTCURRENCY,
EXCHANGERATE,
AMOUNTNETLO,
AMOUNTNETEX,
AMOUNTTOTALLO,
AMOUNTTOTALEX,
DUEDATE,
COMPANY)
select ar_financedetail.document,
ar_document.document,
ar_document.documentcurrency,
ar_document.exchangerate,
ar_financedetail.amountlo,
ar_financedetail.amountex,
ar_financedetail.amountlo,
ar_financedetail.amountex,
ar_document.duedate,
ar_document.company
from ar_financedetail ,
ar_document
where ar_financedetail.finance=ar_document.financetargetprocess and
ar_financedetail.finance=:new.financetargetprocess and
ar_document.document=:new.document and
ar_financedetail.indicator='S';
end if;
END ;