Display Metadata Differences between Tables

Use this API to display the differences found when comparing metadata in two tables.

Name

DME_PUB_DF_DATA_MODEL.get_tab_metadata_diff

Signature

FUNCTION GET_TAB_METADATA_DIFF  
(piCompID		IN CDR_NAMINGS.COMPANY_ID%TYPE
				,piSrcTabObjID		IN CDR_NAMINGS.OBJ_ID%TYPE
				,piSrcTabObjVer		IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE
				,piTgtTabObjID		IN CDR_NAMINGS.OBJ_ID%TYPE
				,piTgtTabObjVer		IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE
				) RETURN dme_char_coll;

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• COMPANY_ID (Mandatory): To get your company ID, use CDR_PUB_DEF_FACTORY_UTILS.GetCompanyId.
• TABLE1_OBJID (Mandatory): The object ID of the first table being compared.
• TABLE1_OBJVER (Mandatory): The object version of the first table being compared.
• TABLE2_OBJID (Mandatory): The object ID of the second table being compared.
• TABLE2_OBJVER (Mandatory): The object version of the second table being compared.