10: --
11: procedure insert_xml_into_table (p_table_name in varchar2,
12: p_locator in clob) is
13:
14: l_saveCtx DBMS_XMLSave.CtxType;
15: l_rows number(15);
16: l_length number(15);
17: l_proc varchar2(73) := g_package || 'insert_xml_into_table';
18:
18:
19: BEGIN
20: hr_utility.set_location('Entering:'|| l_proc, 10);
21: if dbms_lob.getlength(p_locator) > length('') + length('
22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;
19: BEGIN
20: hr_utility.set_location('Entering:'|| l_proc, 10);
21: if dbms_lob.getlength(p_locator) > length('') + length('
22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;
27: --
20: hr_utility.set_location('Entering:'|| l_proc, 10);
21: if dbms_lob.getlength(p_locator) > length('') + length('
22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;
27: --
28: hr_utility.set_location('Leaving:'|| l_proc, 20);
21: if dbms_lob.getlength(p_locator) > length('') + length('
22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;
27: --
28: hr_utility.set_location('Leaving:'|| l_proc, 20);
29: END insert_xml_into_table;