Stored Procedure Accelerator Guide for Oracle

Back Next

Compiling the Masking Package

Compile the masking package and create a temporary schema in the DDMADMIN schema.

To create the masking package, run the following script:

DDM_MASKING_SP_SPEC.sql

To create the body of the package, run the following script:

DDM_MASKING_SP_BODY.sql

To create a PUBLIC synonym for the masking package, run the following commands:

CREATE PUBLIC SYNONYM DDM_MASKING_SP FOR <DDMAMDIN>.DDM_MASKING_SP

GRANT EXECUTE ON DDM_MASKING_SP TO PUBLIC

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.