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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.