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

P_TRIGGER command line keyword

P_TRIGGER specifies a PL/SQL function that is executed when parameter values are specified on the command line and when users accept the Runtime Parameter Form. The function must return a boolean value (TRUE or FALSE). For example:

P_TRIGGER="Is begin IF UPPER(DESTYPE) = 'PRINTER' 
AND EMPNAME = 'SMITH' THEN RETURN(TRUE); ELSE 
RETURN(FALSE); END IF; end;"

This keyword is only used when DTYPE=REGISTER.

The executables that can use this keyword are:

rwbuilder no
rwrun no
rwclient no
rwcgi no
rwserver no
rwservlet no
rwconverter yes

Syntax

P_TRIGGER=plsql_function

Values

Values

plsql_function

Any valid PL/SQL function that returns a boolean value.

See also

Command line keywords

Using the command line

Running a report from the command line