PRINT_POST_PROCESSED_SOURCE

The PRINT_POST_PROCESSED_SOURCE procedure is used to print the PL source code after conditional compilation.

Syntax

The PRINT_POST_PROCESSED_SOURCE procedure supports the following three overloading forms:

Retrieve by object type, schema name, and object name

DBMS_PREPROCESSOR.PRINT_POST_PROCESSED_SOURCE(
    object_type  VARCHAR2,
    schema_name  VARCHAR2,
    object_name  VARCHAR2);

Obtain by source code string

DBMS_PREPROCESSOR.PRINT_POST_PROCESSED_SOURCE(
    source  VARCHAR2);

Obtain from the source code repository

DBMS_PREPROCESSOR.PRINT_POST_PROCESSED_SOURCE(
    source  source_lines_t);

Parameters

Usage instructions

• The PRINT_POST_PROCESSED_SOURCE process calls the GET_POST_PROCESSED_SOURCE function to obtain the post-processed source code, and then uses DBMS_OUTPUT.PUT_LINE to print it out line by line.
• When using overloaded forms of object types, schema names, or object names, ensure that the specified object exists in the database and its type matches.
• The current version does not support this method through an overloaded form of the source code set.

Examples

DECLARE
  source VARCHAR2(32767);
BEGIN
  source := 'CREATE OR REPLACE PACKAGE my_pkg IS
  $IF DBMS_DB_VERSION.VER_LE_21 $THEN
    SUBTYPE my_type IS NUMBER;
  $ELSE
    SUBTYPE my_type IS VARCHAR2(100);
  $END
  PROCEDURE p;
END;';
  DBMS_PREPROCESSOR.PRINT_POST_PROCESSED_SOURCE(source);
END;
/