| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-02 |
|
|
View PDF |
Within an OLAP DML program, the ARGCOUNT function returns the number of arguments that were specified when the current program was invoked.
Return Value
INTEGER
Syntax
ARGCOUNT
Examples
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
...