---

OLAP_ON Function

The OLAP_ON function returns a boolean indicating whether or not the OLAP option is installed in the database.

Note:

You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.

Syntax

OLAP_ON ( )
    RETURN BOOLEAN;

Returns

The value of the OLAP parameter in the V$OPTION table.

Example

The following PL/SQL code tests the value returned by OLAP_ON and returns a status message.

BEGIN
          IF dbms_aw.olap_on() = true
             THEN dbms_output.put_line('The OLAP option is installed');
          ELSE dbms_output.put_line('The OLAP option is not installed');
          END IF;
END;
/

The OLAP option is installed