If the stored routine is a user-defined table function, the Rule Engine rewrites the SQL statement so that the Java Action receives the altered statement.

The Dynamic Data Masking user defines a temporary Oracle schema in the DefMaskRSSym security rule. To mask stored procedure outputs, Dynamic Data Masking dynamically creates a temporary stored procedure in the temporary schema. The temporary stored procedure creates global temporary tables within the temporary schema based on the structure of the result set. It then populates the table with the data in the temporary schema. Dynamic Data Masking names the tables in the temporary schema in the following way:

T_<Timestamp>

For example, a table in the temporary schema might have the following name:

T_5290365863

The timestamp is an automatically generated number.

The temporary stored procedure forms SELECT queries for each table in the temporary schema and masks the queries based on the security rules.