Develop a library of SQL functions

You can develop a library of custom PL/SQL functions, including conversions and derivations. Custom functions are always static references and can reference lookup tables; see Set up reference data.

These custom functions are available for reference from expressions in:

Transformations
Validation Checks
Custom Listings
Data Masking

Note:

Standard Oracle SQL functions are also available.

You must define each function in Oracle Life Science Data Hub as an Oracle LSH program; see Create custom programs.

Each static reference program must:

Be created in an Oracle LSH application area in the DMW_UTILS domain.
Be installed in a work area with a Usage Intent of Production.
Have a validation status of Production.
Have its source code marked as Shareable in Oracle LSH.

Run public API DME_PUB_XFORM_MAP.populateStaticPackages whenever you add, modify, or remove a static package. This makes the new or changed package available for use or, in the case of removing a program, makes it unavailable.

Parent topic: Create custom programs, listings, and filters, and set up reference data