Oracle | DBMS_AW

Oracle DBMS_AW_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Defines the interfaces for the OLAP script procedures

AUTHID CURRENT_USER

Dependencies

APS_VALIDATE	DBMS_AW_LIB	XOQ_VALIDATE
DBMS_AW	DBMS_OLAPI_LIB

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtawi.plb

Subprograms

EVAL_NUMBER_PROC	NOOP	OLAP_SCRIPT_END
EVAL_TEXT_PROC	OLAPI_RUN_DML	OLAP_SCRIPT_START

EVAL_NUMBER_PROC

Undocumented dbms_aw_internal.eval_number_proc( cmd IN VARCHAR2, ret OUT NUMBER);

DECLARE

       outVal NUMBER;

      BEGIN

        dbms_aw_internal.eval_number_proc(7, outVal);

        dbms_output.put_line(outVal);

      END;

      /

      7

      

      PL/SQL procedure successfully completed.

EVAL_TEXT_PROC

Undocumented dbms_aw_internal.eval_text_proc( cmd IN VARCHAR2, ret OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

        dbms_aw_internal.eval_text_proc('LIVE', outVal);

        dbms_output.put_line(outVal);

      END;

      /

      *

      ORA-34492: Analytic workspace object LIVE does not exist.

NOOP

No Operation dbms_aw_internal.noop;

exec dbms_aw_internal.noop;

      

      PL/SQL procedure successfully completed.

OLAPI_RUN_DML

Undocumented dbms_aw_internal.olapi_run_dml( command IN VARCHAR2 objprot IN BINARY_INTEGER);

exec dbms_aw_internal.olapi_run_dml('INSERT INTO test VALUES 1', 1);

          
      *

      ORA-33776: INSERT is not a command.

OLAP_SCRIPT_END

OLAP Post-script dbms_aw_internal.olap_script_end;

exec dbms_aw_internal.olap_script_end;

      

      PL/SQL procedure successfully completed.

OLAP_SCRIPT_START

OLAP Pre-script dbms_aw_internal.olap_script_start;

exec dbms_aw_internal.olap_script_start;

      

      PL/SQL procedure successfully completed.