OraFAQ Forum: Forms » Cannot delete child values

Home » Developer & Programmer » Forms » Cannot delete child values (Forms 6i)

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

Cannot delete child values [message #352506]

Wed, 08 October 2008 01:46

adchax
Messages: 32
Registered: June 2008

Member

Hi
In my form I have a block A that has 3 children B C and D.They have foreign key constraints with the 3 blocks.The relation property for delete is set to 'Cascading'.
Yet when i delete the parent record,the child information disappers but when i try to save it,it gives me teh following error:
FRM-40735: PRE-DELETE trigger raised unhandled exception ORA-02292

Report message to a moderator

Re: Cannot delete child values [message #352643 is a reply to message #352506]

Wed, 08 October 2008 14:38

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

Senior Member
Account Moderator

What does PRE-DELETE trigger do?

Report message to a moderator

Re: Cannot delete child values [message #352675 is a reply to message #352506]

Wed, 08 October 2008 22:50

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

LF means: what code do you currently have in your 'pre-delete' trigger?

David

Report message to a moderator

Re: Cannot delete child values [message #352682 is a reply to message #352675]

Thu, 09 October 2008 00:12

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

Senior Member
Account Moderator

Right! It appears that you understand me better than I do /forum/fa/1587/0/

Report message to a moderator

Re: Cannot delete child values [message #352690 is a reply to message #352682]

Thu, 09 October 2008 00:51

adchax
Messages: 32
Registered: June 2008

Member

PRE DELETE was created automatically while creating the joing relation between the parent and 3 child.
I tried forcing a commit in the PRE DELETE even that did not help.
It contains delete statements for all the 3 childrem

[Updated on: Thu, 09 October 2008 01:03]

Report message to a moderator

Re: Cannot delete child values [message #353295 is a reply to message #352690]

Mon, 13 October 2008 04:55

adchax
Messages: 32
Registered: June 2008

Member

I managed to solve the problem in a crude way..I explicetly wrote the delete statements in the PRE DELETE!
Thanks

Report message to a moderator

Previous Topic:	Key is not navigating in Hierarchical Tree
Next Topic:	skin builder for developer 6.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 00:55:15 CST 2025