Oracle® OLAP DML Reference 11g Release 2 (11.2) E17122-08 |
|
|
PDF · Mobi · ePub |
Within an OLAP DML program, the ARGCOUNT function returns the number of arguments that were specified when the current program was invoked.
Example 7-21 Checking the Number of Arguments
In the following example, the program, a user-defined function, verifies that three arguments are passed. When the number of arguments passed is not equal to 3, the program terminates with -1
as a return value.
DEFINE threearg PROGRAM INTEGER LD User-defined function expecting three arguments PROGRAM ARGUMENT division TEXT ARGUMENT product TEXT ARGUMENT month MONTH IF ARGCOUNT NE 3 THEN RETURN -1 ELSE DO ...