|Oracle9i OLAP User's Guide
Release 2 (18.104.22.168)
Part Number A95295-02
EXECUTE procedure executes one or more OLAP DML commands and directs the output to a printer buffer. It is typically used to manipulate analytic workspace data within an interactive SQL session.
When you are using SQL*Plus, you can direct the printer buffer to the screen by issuing the following command:
If you are using a different program, refer to its documentation for the equivalent setting.
Input and output is limited to 4K. For larger values, refer to the
INTERPCLOB functions in this package.
One or more OLAP DML commands separated by semicolons.
Output from the OLAP engine in response to the OLAP commands.
The SQL processor evaluates the OLAP DML commands, either in whole or in part, before sending them to Oracle OLAP for processing. Follow these guidelines when formatting the OLAP DML commands in the
') in an OLAP DML command, use two single quotes (
''). The SQL processor strips one of the single quotes before it sends the OLAP DML command to Oracle OLAP.
") indicates the beginning of a comment.
This procedure does not print the output of the DML commands when you have redirected the output by using the OLAP DML
The following sample SQL*Plus session attaches an analytic workspace named
XADEMO, creates a formula named
XADEMO, and displays the new formula definition.
SQL> SET SERVEROUT ON SQL> EXECUTE DBMS_AW.EXECUTE('AW ATTACH xademo RW; DEFINE cost_pp FORMULA LAG(analytic_cube_f.costs, 1, time, LEVELREL time_levelrel)'); PL/SQL procedure successfully completed. SQL> EXECUTE DBMS_AW.EXECUTE('DESCRIBE cost_pp'); DEFINE COST_PP FORMULA DECIMAL <CHANNEL GEOGRAPHY PRODUCT TIME> EQ lag(analytic_cube_f.costs, 1, time, levelrel time.levelrel) PL/SQL procedure successfully completed.