OLAP_RUNNING function returns a boolean indicating whether or not the OLAP option has been initialized in the current session. Initialization occurs when you execute an OLAP DML command (either directly or by using an OLAP PL/SQL or Java package), query an analytic workspace, or execute the STARTUP Procedure.
Note:You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.
OLAP_RUNNING( ) RETURN BOOLEAN;
TRUE if OLAP has been initialized in the current session, or
FALSE if it has not.
The following PL/SQL script tests whether the OLAP environment has been initialized, and starts it if not.
BEGIN IF dbms_aw.olap_running() THEN dbms_output.put_line('OLAP is already running'); ELSE dbms_aw.startup; IF dbms_aw.olap_running() THEN dbms_output.put_line('OLAP started successfully'); ELSE dbms_output.put_line('OLAP did not start. Is it installed?'); END IF; END IF; END; / OLAP started successfully