Oracle | DBMS_AW

Oracle DBMS_AW_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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 (new 21c)

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 (new 21c)

Undocumented dbms_aw_internal.eval_text_proc( CMD IN VARCHAR2, RET OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

      --  dbms_aw_internal.olap_script_start;

        dbms_aw_internal.eval_text_proc('LIVE', outVal);

        dbms_output.put_line(outVal);

      END;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_AW_INTERNAL", line 54

      ORA-06512: at "SYS.DBMS_AW_INTERNAL", line 65

      ORA-06512: at line 4

NOOP (new 21c)

No Operation dbms_aw_internal.noop;

exec dbms_aw_internal.noop;

      

      PL/SQL procedure successfully completed.

OLAPI_RUN_DML (new 21c)

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

exec dbms_aw_internal.olapi_run_dml('EXECUTE', 1);

      BEGIN dbms_aw_internal.olapi_run_dml('EXECUTE', 1); END;

      *

      ERROR at line 1:

      ORA-33776: EXECUTE is not a command.

      ORA-06512: at "SYS.DBMS_AW_INTERNAL", line 28

      ORA-06512: at line 1

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.