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
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('
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('
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 ;