Oracle DBMS_AW_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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/dbmsawi.sql
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)
??? dbms_aw_internal.noop;
exec dbms_aw_internal.noop;

PL/SQL procedure successfully completed.
 
OLAPI_RUN_DML (new 21c)
??? 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_STATS
DBMS_AW_XML
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx