Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

CALLTYPE

Within an OLAP DML program, the CALLTYPE function indicates whether a program was invoked as a function, as a command, by using a CALL statement, or triggered by the execution of an OLAP DML statement.

The return value of CALLTYPE is either FUNCTION, COMMAND, or CALL. CALLTYPE is for use only within programs.

Return Value

TEXT

The return value of CALLTYPE is:

Syntax

CALLTYPE

Notes


Handling Arguments

The CALLTYPE function is helpful when you want to find out how your program has been called, so that you can handle appropriately any arguments that have been passed. See ARGUMENT for information on the differences in argument handling that depend on how a program is invoked. See CALL for information on calling programs.

Examples

Example 8-36 Determining the Calling Method

This sample program, called myprog, demonstrates how CALLTYPE returns different values depending on how the program is invoked.

DEFINE myprog PROGRAM
PROGRAM
SHOW CALLTYPE
RETURN('This is the return value')
END

The following statements invoke myprog: 1) as command; 2) with a CALL statement; 3) as a function.

myprog
CALL myprog
SHOW myprog

The three statements send the following output to the current outfile. Note that the return value of myprog appears only when the program is called as a function.

COMMAND
CALL
FUNCTION
This is the return value