The DBMS_PREPROCESSOR system package provides functionality for preprocessing PL source code. You can use this package to obtain or print PL source code after conditional compilation.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Usage instructions for DBMS_PREPROCESSOR
The DBMS_PREPROCESSOR system package supports preprocessing the following types of PL objects: PACKAGE, PACKAGE BODY, PROCEDURE, FUNCTION, TRIGGER, TYPE, and TYPE BODY.
Overview of the DBMS_PREPROCESSOR Subprogram
The following table lists the DBMS_PREPROCESSOR subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| PRINT_POST_PROCESSED_SOURCE | Print the PL source code after conditional compilation. |
| GET_POST_PROCESSED_SOURCE | Retrieves the PL source code after conditional compilation. |