|Oracle9i OLAP User's Guide
Release 2 (18.104.22.168)
Part Number A95295-02
INTERP_SILENT procedure executes one or more OLAP DML commands and suppresses all output from them. It does not suppress error messages from the OLAP command interpreter.
Input to the
INTERP_SILENT function is limited to 4K. If you want to display the output of the OLAP DML commands, use the
EXECUTE procedure, or the
One or more OLAP DML commands separated by semi-colons.
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.
The following commands show the difference in message handling between
INTERP_SILENT. Both commands attach the XADEMO analytic workspace in read-only mode. However,
EXECUTE displays a warning message, while
INTERP_SILENT does not.
SQL> EXECUTE DBMS_AW.EXECUTE('AW ATTACH xademo'); IMPORTANT: Analytic workspace XADEMO is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it. PL/SQL procedure successfully completed. SQL> EXECUTE DBMS_AW.INTERP_SILENT('AW ATTACH xademo'); PL/SQL procedure successfully completed.