Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on PLSQL_MODULE reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| ORACLE_OBJECT_TYPE_REFERENCE | Cascade delete, if ORACLE_OBJECT_TYPE deleted (Owning foreign key) |
| JAVA_MODULE_REFERENCE | Nullify reference, if JAVA_MODULE deleted |
| ORACLE_TYPE_REFERENCE | Nullify reference, if ORACLE_TYPE deleted |
Impact on child element types if PLSQL_MODULE is deleted
| Impact on children | Via child reference property |
| Cascade delete CHANGE_HISTORY | CHANGE_HISTORY.MODULE_REFERENCE |
| Cascade delete DATABASE_SYNONYMS | DATABASE_SYNONYM.PLSQL_MODULE_REFERENCE |
| Cascade delete DATASTRUCTURES | DATASTRUCTURE.PLSQL_MODULE_REFERENCE |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete DISTRIBUTED_PROCESSINGS | DISTRIBUTED_PROCESSING.MODULE_REFERENCE |
| Cascade delete DOCUMENT_ATTACHMENTS | DOCUMENT_ATTACHMENT.ELEMENT_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.PART_OF_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.USE_OF_REFERENCE |
| Cascade delete FOLDER_MEMBERS | FOLDER_MEMBER.MEMBER_OBJECT |
| Cascade delete MODULE_ARGUMENTS | MODULE_ARGUMENT.PLSQL_MODULE_REFERENCE |
| Cascade delete MODULE_ASSUMPTIONS | MODULE_ASSUMPTION.MODULE_REFERENCE |
| Cascade delete MODULE_BUSINESS_UNITS | MODULE_BUSINESS_UNIT.MODULE_REFERENCE |
| Cascade delete MODULE_FUNCTIONS | MODULE_FUNCTION.MODULE_REFERENCE |
| Cascade delete MODULE_NETWORKS | MODULE_NETWORK.PARENT_MODULE_REFERENCE |
| Cascade delete MODULE_PROGRAM_DATA | MODULE_PROGRAM_DATUM.PLSQL_MODULE_REFERENCE |
| Cascade delete PLSQL_MOD_IMPLEMENTATIONS | PLSQL_MOD_IMPLEMENTATION.PLSQL_MODULE_REFERENCE |
| Cascade delete PROBLEM_TO_MODULES | PROBLEM_TO_MODULE.MODULE_REFERENCE |
| Cascade delete PROGRAM_DATA | PROGRAM_DATUM.PLSQL_MODULE_REFERENCE |
| Cascade delete SERVER_OBJECT_USAGES | SERVER_OBJECT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete SET_MEMBER_ITEMS | SET_MEMBER_ITEM.ELEMENT_REFERENCE |
| Cascade delete SYSTEM_OBJECTIVE_OF_MODULES | SYSTEM_OBJECTIVE_OF_MODULE.MODULE_REFERENCE |
| Block, if DATABASE_TRIGGERS exist | DATABASE_TRIGGER.PLSQL_MODULE_REFERENCE |
| Block, if DATASTRUCTURE_ITEMS exist | DATASTRUCTURE_ITEM.CURSOR_REFERENCE |
| Block, if DATASTRUCTURE_ITEMS exist | DATASTRUCTURE_ITEM.PLSQL_MODULE_REFERENCE |
| Block, if MODULE_NETWORKS exist | MODULE_NETWORK.CHILD_MODULE_REFERENCE |