Setting Validation Rules

You can choose a method of validating the Parameter's value. If you select a method, the system validates the Parameter value when the Program is submitted for execution. If the Parameter has an invalid value, the system returns an error message and does not execute the Program.

Note:

If you set a default value, the system validates its data type and length each time you modify the Parameter.

You can choose one of the following methods of validating the Parameter's value:

  • None. You can choose to accept any value entered by the user.

  • Programmatic. You can define an Oracle LSH Program specifically for the purpose of dynamically validating the Parameter value. You must check in and install the Program. See Defining Programatically Generated Lists of Values and Value Validation for further information.

    Click the Search icon and specify the Program that contains the Source Code you want to use to validate the value of the Parameter.

  • Validate Against LOV. If you defined a static list of values for the Parameter, the system accepts the entered value only if it appears on that list.