A script-enabled browser is required for this page to function properly.

Validation trigger

Validation triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form.  (Notice that this means each validation trigger may fire twice when you execute the report.)   Validation triggers are also used to validate the Initial Value property of the parameter. The function must return a boolean value (TRUE or FALSE).   Depending on whether the function returns TRUE or FALSE, the user is returned to the Runtime Parameter Form. You can access validation triggers from the Object Navigator, the PL/SQL Editor, or the Property Inspector (Validation Trigger property).

Definition Level

Parameter

On Failure

The user is returned to the parameter value in the Runtime Parameter Form where they can either change it or cancel the Runtime Parameter Form.

Restrictions

Examples

This function prevents the runtime user from  sending report output anywhere except a printer. The user will be returned to the Runtime Parameter Form unless PRINTER is specified as the destination type (DESTYPE).

function DESTYPEValidTrigger return boolean is
begin
  IF UPPER(:DESTYPE) = 'PRINTER' THEN
RETURN(TRUE);
ELSE
RETURN(FALSE);
END IF;
end;

See also

About triggers

About validation triggers

Validating a parameter value at runtime