OraFAQ Forum: Forms » Pre-delete trigger

Home » Developer & Programmer » Forms » Pre-delete trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Pre-delete trigger [message #159468]

Sun, 19 February 2006 23:39

juicyapple
Messages: 92
Registered: October 2005

Member

I have problem to delete record through oracle form which is in master details form. Thus, I add a pre-delete trigger to delete the details of the records, but when I run the form, it doesn't raise the trigger...

Have any idea? I just want to delete records...

Thanks

Report message to a moderator

Re: Pre-delete trigger [message #159491 is a reply to message #159468]

Mon, 20 February 2006 00:56

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If the master-detail relationship is created properly, there is the ON-CHECK-DELETE-MASTER trigger which fires before the PRE-DELETE trigger you wrote. Finding child records, it raises an error and PRE-DELETE trigger is never executed.

Therefore, move the code from the PRE-DELETE trigger into the ON-CHECK-DELETE-MASTER trigger (or call first from the second one; should be the same).

Report message to a moderator