How To DELETE Cascade When Working With RDF Data (Doc ID 1085728.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 11.1.0.7 to 11.2.0.1 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Goal

Requirement:
Lets say we have Patient relationshiop to many Treatment_Plans and then plans relate to many Patient_Geometries

So we will have the RDF table with triples

John Smith has Treatment_plan1
John Smith has Treatment_plan2
John Smith has Treatment_plan3
...
Treatment_plan1 has Patient_Geometry1
Treatment_plan1 has Patient_Geometry2
Treatment_plan1 has Patient_Geometry3
Treatment_plan2 has Patient_Geometry1
Treatment_plan2 has Patient_Geometry2
Treatment_plan2 has Patient_Geometry3
...

The front end application will delete 'John Smith'

Is there an example of a trigger (server database side) that will go and remove all the related data, in this case the triples with subjects Treatment_plan1, Treatment_plan2 and Treatment_plan3? and also any triples that have Patient_Geometry1, Patient_Geometry2 and Patient_Geometry3 and so on?

Note: The children records do not have other relationship. In other words:

Treatment_plan1, Treatment_plan2 and Treatment_plan3 are related just to John Smith and no other Patient. Same as cascading children Patient_Geometry1 is related to just Treatment_plan1.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms