I'm using jdeveloper 22.214.171.124.0
I have defined master and detail as view link.
I would like that when the user delete a master row, all conneced detail rows will also be deleted.
(without using delete cascade on DB).
How should I implement it?
I was trying first to use the composition association -> implement cascade delete
and it deleted the detail rows as I expected.
But it caused another problem,
The problem is:
in my case the user adds the master and detail in the same form,
and when he first adds rows to the detail table he gets an InvalidOwnerException error.
I don't know how to solve it so I decided to give up the composition association and to delete the detail rows programatically.
but I didn't find how to do that.
also I checked the thread that user707 added above, as I understand it's the same problem as mine, but with no correct answer.
So if anyone can help me with a good answer and a way to get out of the loop, I will be very glad.
It's realy urgent.
Thanks a lot!