DBA Data[Home] [Help]

APPS.BIS_PORTLET_PMREGION dependencies on DBMS_LOB

Line 7660: dbms_lob.createtemporary(x_clob, true);

7656: IF ((v_buffer_length + v_string_length) <= 32000) THEN
7657: x_buffer := x_buffer || p_string;
7658: ELSE
7659: -- create the CLOB object
7660: dbms_lob.createtemporary(x_clob, true);
7661:
7662: -- append the buffer and the new string to the created CLOB
7663: dbms_lob.writeappend(x_clob, v_buffer_length, x_buffer);
7664: dbms_lob.writeappend(x_clob, v_string_length, p_string);

Line 7663: dbms_lob.writeappend(x_clob, v_buffer_length, x_buffer);

7659: -- create the CLOB object
7660: dbms_lob.createtemporary(x_clob, true);
7661:
7662: -- append the buffer and the new string to the created CLOB
7663: dbms_lob.writeappend(x_clob, v_buffer_length, x_buffer);
7664: dbms_lob.writeappend(x_clob, v_string_length, p_string);
7665: END IF;
7666: ELSE
7667: -- append the new string to the existing CLOB

Line 7664: dbms_lob.writeappend(x_clob, v_string_length, p_string);

7660: dbms_lob.createtemporary(x_clob, true);
7661:
7662: -- append the buffer and the new string to the created CLOB
7663: dbms_lob.writeappend(x_clob, v_buffer_length, x_buffer);
7664: dbms_lob.writeappend(x_clob, v_string_length, p_string);
7665: END IF;
7666: ELSE
7667: -- append the new string to the existing CLOB
7668: dbms_lob.writeappend(x_clob, v_string_length, p_string);

Line 7668: dbms_lob.writeappend(x_clob, v_string_length, p_string);

7664: dbms_lob.writeappend(x_clob, v_string_length, p_string);
7665: END IF;
7666: ELSE
7667: -- append the new string to the existing CLOB
7668: dbms_lob.writeappend(x_clob, v_string_length, p_string);
7669: END IF;
7670:
7671: EXCEPTION
7672: WHEN OTHERS THEN

Line 7735: dbms_lob.freetemporary(x_clob);

7731: IS
7732:
7733: BEGIN
7734:
7735: dbms_lob.freetemporary(x_clob);
7736:
7737: EXCEPTION
7738: WHEN OTHERS THEN
7739: null;