Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Stored Procedure Result Set Masking
  9. Integration with Informatica Products
  10. Appendix A: XML Functions Reference
  11. Appendix B: Glossary

PL/SQL Function Lookup

PL/SQL Function Lookup

The PL/SQL lookup type runs a PL/SQL function that returns the value for the defined symbol name.
The following table describes the PL/SQL function lookup parameters:
Parameter
Description
Symbol Name
The name of the symbol to be populated. The symbol name must begin with a letter and can contain ASCII characters, numbers, and underscores.
Keep Per Session
Defines whether the symbol is a global symbol.
Select if you want to define a global symbol. A global symbol exists until the client disconnects from the database.
If you clear the
Keep Per Session
check box, the symbol exists only during the SQL request.
Lookup Type
The type of lookup. When you select
PL/SQL Function
, the applicable fields appear.
Database
The Dynamic Data Masking database name where the lookup function runs. The database can be any db node available in Dynamic Data Masking server.
Function Name
The fully qualified name of the PL/SQL function. For example,
HR.dbo.get_lookup_for user
.
Include Database Username
Select if the function uses a database user name parameter. The database username parameter defines the user for the session.
Include OS User
Select if the function uses an operating system user parameter. The operating system user parameter defines the user name for the user logged in to the operating system.
Include Client Host
Select if the function uses a client host parameter. The client host parameter defines the client host name or IP address.
Include Program Name
Select if the function uses a program name parameter. The program name defines the application or program name.
Include Statement
Select if the function uses a statement parameter. The statement parameter defines the SQL statement text. You must define the statement in VARCHAR.
Include Text Value
Select if the function uses a text value parameter.
Value to Use
If you selected
Include Text Value
, enter a text value parameter. You can use text or a global symbol to define the text value.