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;
Please indicate "Mark as Answer" if a post has answered the question.
Yet another developer blog <-- visit my blog
Contributor
2350 Points
1014 Posts
Oracle Error in Trigger?
Apr 19, 2010 08:33 AM|duttavr|LINK
I have a following delete trigger in oracle.
Participant
1960 Points
259 Posts
Re: Oracle Error in Trigger?
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:
Yet another developer blog <-- visit my blog
Contributor
2350 Points
1014 Posts
Re: Oracle Error in Trigger?
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?
Participant
1960 Points
259 Posts
Re: Oracle Error in Trigger?
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:
http://www.techonthenet.com/oracle/errors/ora04091.php
Yet another developer blog <-- visit my blog
Contributor
2350 Points
1014 Posts
Re: Oracle Error in Trigger?
Apr 20, 2010 09:52 AM|duttavr|LINK
Thant's great. Thanks a lot for the reply.