About Customizing Object Validation

You can use a package called CDR_DF_CUSTOM_VALIDATION to set your own standards for object definitions.

The internal procedures createNaming and modifyNaming call this package each time a user creates or modifies an object definition or instance and commits the changes. By default, the package returns a value of True and the standard application logic for creating or updating an object proceeds.

However, you can modify this package to enforce your own rules—for example, naming conventions—so that the package returns False and displays an error message if one or more rules are violated. The operation fails and the system does not invoke the standard application logic for creating or updating an object.

You can set a rule for any attribute of any object type (not just the name). You can set different rules for different object types.

To see all attributes for all object types predefined in the Oracle Life Sciences Data Hub (Oracle LSH), enter the following query at a SQL prompt:

desc apps.cdr_naming_version_obj_type