Hi All,
i have a scenario where i am inserting record in one table example EMP in the after insert trigger i have a cursor which selectes records from multiple tables along with table emp and need to get data for new employeee inserted
cursor s1
select a.aa
b.bb
e.empno
e.ename
from xx a,
yy b
emp e
where a.id = b.id
and b.id = e.id
and e.emmpno = :new.empno
and sysdate between e.start_date and e.end_date
since the record is not committed yet my cursor doesnot fetch the records . how to handle as there is no after commit trigger which can fetch new record inserted in the emp table.