DBA Data[Home] [Help]

APPS.PA_OLAP_PVT dependencies on DBMS_LOB

Line 169: dbms_lob.writeappend(v_xml_clob, LENGTH(v_line), v_line);

165: AS
166: v_line varchar2(2000);
167: BEGIN
168: v_line := p_line || ' ';
169: dbms_lob.writeappend(v_xml_clob, LENGTH(v_line), v_line);
170: END add_lob_line;
171:
172: procedure refresh_dm
173: as

Line 299: dbms_lob.createtemporary(v_xml_clob,TRUE);

295:
296: begin
297: null;
298:
299: dbms_lob.createtemporary(v_xml_clob,TRUE);
300: dbms_lob.open(v_xml_clob, DBMS_LOB.LOB_READWRITE);
301:
302:
303: pa_olap_pvt.add_lob_line('

Line 300: dbms_lob.open(v_xml_clob, DBMS_LOB.LOB_READWRITE);

296: begin
297: null;
298:
299: dbms_lob.createtemporary(v_xml_clob,TRUE);
300: dbms_lob.open(v_xml_clob, DBMS_LOB.LOB_READWRITE);
301:
302:
303: pa_olap_pvt.add_lob_line(' 304: pa_olap_pvt.add_lob_line(' Version="1.3" ');

Line 4399: dbms_lob.close(v_xml_clob);

4395: pa_olap_pvt.add_lob_line(' ');
4396: pa_olap_pvt.add_lob_line(' ');
4397:
4398:
4399: dbms_lob.close(v_xml_clob);
4400: --dbms_output.put_line(v_xml_clob);
4401: dbms_cube.import_xml(v_xml_clob);
4402:
4403: end ;