Oracle | ODM_MODEL

Oracle ODM_MODEL_UTIL 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 Data Mining Model Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_DM_MODEL_EXP	DBMS_STANDARD
DBMS_DATA_MINING	DBMS_DM_MODEL_IMP	DMP_SEC
DBMS_DATA_MINING_INTERNAL	DBMS_LOB	DMP_SYS
DBMS_DATA_MINING_TRANSFORM	DBMS_PREDICTIVE_ANALYTICS	DMUTIL_LIB
DBMS_DM_EXP_INTERNAL	DBMS_SQL	ODM_UTIL

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

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

Subprograms

CHOP_UP	EXPRESSION_REC_TO_CLOB	UPCASE
CLOB_TO_EXPRESSION_REC	TABLE_EXIST	VIRTUAL_NESTED_XFORM
DM_ENABLED_CHECK

CHOP_UP

Undocumented odm_model_util.chop_up( P_SHORT_STMT IN VARCHAR2, P_LONG_STMT IN OUT sys.dbms_sql.varchar2s, P_LONG_COUNT IN OUT BINARY_INTEGER);

TBD

CLOB_TO_EXPRESSION_REC

Undocumented odm_model_util.clob_to_expression_rec(p_clob IN CLOB) RETURN sys.dbms_data_mining_transform.expression_rec;

TBD

DM_ENABLED_CHECK

Undocumented odm_model_util.dm_enabled_check;

exec odm_model_util.dm_enabled_check;

EXPRESSION_REC_TO_CLOB

Undocumented odm_model_util.expression_rec_to_clob( p_expr IN sys.dbms_data_mining_transform.expression_rec RETURN CLOB;

TBD

TABLE_EXIST

Returns TRUE if a table exists, else FALSE

Calls DBMS_ASSERT to validate the name. odm_model_util.table_exist(p_table_name IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF odm_model_util.table_exist('SYS.TAB$') THEN

          dbms_output.put_line('Exists');

        ELSE

          dbms_output.put_line('Not Found');

        END IF;

      END;

      /

      BEGIN

      *

      ERROR at line 1:

      ORA-44003: invalid SQL name

      ORA-06512: at "SYS.DBMS_ASSERT", line 190

      ORA-06512: at "SYS.ODM_MODEL_UTIL", line 80

      ORA-06512: at line 2

      

      BEGIN

        IF odm_model_util.table_exist('TAB$') THEN

          dbms_output.put_line('Exists');

        ELSE

          dbms_output.put_line('Not Found');

        END IF;

      END;

      /

      Exists

      

      PL/SQL procedure successfully completed.

UPCASE

Upper cases a string.

There are multiple examples of Oracle not using the UPPER function ... but no available explanation as to why some developers feel compelled to reinvent the wheel. odm_model_util.upcase( p_out_name OUT VARCHAR2, p_in_name IN VARCHAR2);

DECLARE

       iVal dbms_id := 'Morgan';

       oVal dbms_id;

      BEGIN

        odm_model_util.upcase(oVal, iVal);

        dbms_output.put_line(oVal);

      END;

      /

      MORGAN

      

      PL/SQL procedure successfully completed.

VIRTUAL_NESTED_XFORM

Undocumented odm_model_util.virtual_nested_xform( p_expr IN sys.dbms_data_mining_transform.expression_rec RETURN BOOLEAN;

TBD