ut_compound_data_helper.md

UT_COMPOUND_DATA_HELPER

• Constants

• Variables

• Exceptions

• GET_COLUMNS_ROW_FILTER Function

Variables

Name	Code	Description
g_user_defined_type	g_user_defined_type pls_integer := dbms_sql.user_defined_type;
l_res	l_res xmltype;
l_data	l_data ut_data_value := a_column_details.value;
l_key	l_key varchar2(4000) := ut_utils.xmlgen_escaped_string(a_column_details.KEY);
begin	begin l_result := '<'
else	else l_result := l_result
end	end if;
l_result := l_result		'</'
return	return xmltype(l_result);
l_source_column	l_source_column varchar2(500) := a_table_alias
end	end if;
return	return l_filter;

Constants

Name	Code	Description
gc_compare_join_by	gc_compare_join_by constant varchar2(10):='join_by';
gc_compare_unordered	gc_compare_unordered constant varchar2(10):='unordered';
gc_compare_normal	gc_compare_normal constant varchar2(10):='normal';

Exceptions

Name	Code	Description
g_user_defined_type	g_user_defined_type pls_integer := dbms_sql.user_defined_type;
l_res	l_res xmltype;
l_data	l_data ut_data_value := a_column_details.value;
l_key	l_key varchar2(4000) := ut_utils.xmlgen_escaped_string(a_column_details.KEY);
begin	begin l_result := '<'
else	else l_result := l_result
end	end if;
l_result := l_result		'</'
return	return xmltype(l_result);
l_source_column	l_source_column varchar2(500) := a_table_alias
end	end if;
return	return l_filter;

GET_COLUMNS_ROW_FILTER Function

Current get column filter shaving off ROW tag during extract, this not working well with include and XMLTABLE option
so when there is extract we artificially inject removed tag

Syntax

function get_columns_row_filter(
  a_exclude_xpath varchar2, a_include_xpath varchar2,
  a_table_alias varchar2 := 'ucd', a_column_alias varchar2 := 'item_data'
) return varchar2