Last post Apr 20, 2010 09:52 AM by duttavr
Apr 19, 2010 08:33 AM|duttavr|LINK
I have a following delete trigger in oracle.
Apr 20, 2010 07:11 AM|tpeczek|LINK
I'm sorry but nobody can help you here, when you create a trigger against a table, you can't modify/query that table until the trigger/function has completed. In your case it means you can't make this select:
select count(MakeupPayProfileID) from MakeupPayProfile where MakeupPayProfile.MakeupPayProfileID = :old.MakeupPayProfileID;
Apr 20, 2010 09:16 AM|duttavr|LINK
Thanks a lot for providing the reply. could you please provide me any official documentaion sources/links please?
Apr 20, 2010 09:45 AM|tpeczek|LINK
Just google your ORA error (ORA-04091) and you will receive plenty of results, here is one:
Apr 20, 2010 09:52 AM|duttavr|LINK
Thant's great. Thanks a lot for the reply.