Search

User Guide

User Guide

9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

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.

Lookup into Symbol Action

Watch

Comments

0 COMMENTS

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