DBA Data[Home] [Help]

SYS.DBMS_FEATURE_EMX dependencies on XMLTYPE

Line 16: l_detailed_usage_xml xmltype := NULL;

12: -- feature_info clob
13: l_detailed_usage_clob CLOB := NULL;
14:
15: -- feature_info xml
16: l_detailed_usage_xml xmltype := NULL;
17:
18: -- new xml to add to feature_info xml for one report
19: l_report_usage_xml xmltype := NULL;
20:

Line 19: l_report_usage_xml xmltype := NULL;

15: -- feature_info xml
16: l_detailed_usage_xml xmltype := NULL;
17:
18: -- new xml to add to feature_info xml for one report
19: l_report_usage_xml xmltype := NULL;
20:
21: -- xpath key to find out if report already has entry in feature_info xml
22: l_report_usage_key varchar2(32767);
23:

Line 88: xmltype('');

84:
85: -- if no feature_info xml exists, construct a brand new one
86: if (l_detailed_usage_clob is NULL) then
87: l_detailed_usage_xml :=
88: xmltype('');
89: -- otherwise update the existing one
90: else
91: l_detailed_usage_xml := xmltype(l_detailed_usage_clob);
92: end if;

Line 91: l_detailed_usage_xml := xmltype(l_detailed_usage_clob);

87: l_detailed_usage_xml :=
88: xmltype('');
89: -- otherwise update the existing one
90: else
91: l_detailed_usage_xml := xmltype(l_detailed_usage_clob);
92: end if;
93:
94: -- get last db feature usage collection time
95: select nvl(max(last_sample_date), sysdate-7)