2956: END supplier_details_XRD;
2957:
2958: FUNCTION create_address_xml(p_sql_stmt VARCHAR2) RETURN CLOB
2959: IS
2960: queryCtx DBMS_XMLGEN.ctxType;
2961: result CLOB;
2962: BEGIN
2963: queryCtx := DBMS_XMLGEN.newContext(p_sql_stmt);
2964:
2959: IS
2960: queryCtx DBMS_XMLGEN.ctxType;
2961: result CLOB;
2962: BEGIN
2963: queryCtx := DBMS_XMLGEN.newContext(p_sql_stmt);
2964:
2965: DBMS_XMLGEN.setRowTag(
2966: queryCtx
2967: , NULL
2961: result CLOB;
2962: BEGIN
2963: queryCtx := DBMS_XMLGEN.newContext(p_sql_stmt);
2964:
2965: DBMS_XMLGEN.setRowTag(
2966: queryCtx
2967: , NULL
2968: );
2969: DBMS_XMLGEN.setRowSetTag(
2965: DBMS_XMLGEN.setRowTag(
2966: queryCtx
2967: , NULL
2968: );
2969: DBMS_XMLGEN.setRowSetTag(
2970: queryCtx
2971: , 'ADDRESS'
2972: );
2973:
2970: queryCtx
2971: , 'ADDRESS'
2972: );
2973:
2974: --DBMS_XMLGEN.useNullAttributeIndicator(queryCtx,TRUE);
2975:
2976: result := DBMS_XMLGEN.getXml(queryCtx);
2977:
2978: DBMS_XMLGEN.closeContext(queryCtx);
2972: );
2973:
2974: --DBMS_XMLGEN.useNullAttributeIndicator(queryCtx,TRUE);
2975:
2976: result := DBMS_XMLGEN.getXml(queryCtx);
2977:
2978: DBMS_XMLGEN.closeContext(queryCtx);
2979: RETURN result;
2980:
2974: --DBMS_XMLGEN.useNullAttributeIndicator(queryCtx,TRUE);
2975:
2976: result := DBMS_XMLGEN.getXml(queryCtx);
2977:
2978: DBMS_XMLGEN.closeContext(queryCtx);
2979: RETURN result;
2980:
2981: EXCEPTION
2982: WHEN OTHERS THEN