Home » Developer & Programmer » Forms » Cannot delete child values (Forms 6i)
Cannot delete child values [message #352506] Wed, 08 October 2008 01:46 Go to next message
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
Re: Cannot delete child values [message #352643 is a reply to message #352506] Wed, 08 October 2008 14:38 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does PRE-DELETE trigger do?
Re: Cannot delete child values [message #352675 is a reply to message #352506] Wed, 08 October 2008 22:50 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
LF means: what code do you currently have in your 'pre-delete' trigger?

David
Re: Cannot delete child values [message #352682 is a reply to message #352675] Thu, 09 October 2008 00:12 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right! It appears that you understand me better than I do ./fa/1587/0/
Re: Cannot delete child values [message #352690 is a reply to message #352682] Thu, 09 October 2008 00:51 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Key is not navigating in Hierarchical Tree
Next Topic: skin builder for developer 6.0
Goto Forum:
  


Current Time: Mon Dec 05 10:40:57 CST 2016

Total time taken to generate the page: 0.07679 seconds