| Oracle® OLAP DML Reference 11g Release 2 (11.2) E17122-07 | 
 | 
| 
 | 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.
INTEGER
ARGCOUNT
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
     ...