The DBMS_PREPROCESSOR system package provides the capability to preprocess PL source code. You can use this package to obtain or print the PL source code after conditional compilation processing.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
DBMS_PREPROCESSOR usage notes
The DBMS_PREPROCESSOR system package supports preprocessing the following types of PL objects: PACKAGE, PACKAGE BODY, PROCEDURE, FUNCTION, TRIGGER, TYPE, and TYPE BODY.
DBMS_PREPROCESSOR subprogram overview
The following table lists the DBMS_PREPROCESSOR subprograms supported in the current version of OceanBase Database and their descriptions.
Subprogram |
Description |
|---|---|
| PRINT_POST_PROCESSED_SOURCE | Prints the PL source code after conditional compilation processing. |
| GET_POST_PROCESSED_SOURCE | Obtains the PL source code after conditional compilation processing. |