hi PAVB,
i have used Select into.my query is below.what should i use instead of into not get get the no data found error.

create or replace trigger exp_lc_document_txn_status_trg
after update on exp_lc_document_trg
for each row
declare
-- local variables here
workflowID varchar2(16);

begin

select workflow.r_object_id into workflowID

from dm_workflow_s workflow,
dmi_package_s packs,
dmi_package_r packr


where
workflow.r_object_id=packs.r_workflow_id
and packs.r_object_id=packr.r_object_id
and packr.r_component_id=ld.r_object_id
and workflowID <> ' ';



if (:new.TRANSACTION_STATUS <> ld.TRANSACTION_STATUS) THEN

INSERT INTO T_REP_TXN_STATUS
VALUES
(
workflowID,
ld.transaction_status,
sysdate,
sysdate
) ;
end if;


commit;
end exp_lc_document_txn_status_trg;