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 (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.

Related Topics
Built-in Functions
Built-in Packages
DBMS_AW
DBMS_AW_EXP
DBMS_AW_STATS
DBMS_AW_XML
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx