P_TRIGGER
command line keywordP_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 |
P_TRIGGER=plsql_function
Values |
Values |
plsql_function
|
Any valid PL/SQL function that returns a boolean value. |
Running a report from the command line
Copyright © 1984, 2005, Oracle. All rights reserved.