DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on DBMS_LOB

Line 662: l_chunksize := DBMS_LOB.getchunksize(l_element_desc);

658: INTO l_element_desc
659: FROM cs_kb_elements_vl
660: WHERE element_id = p_element_id;
661: --
662: l_chunksize := DBMS_LOB.getchunksize(l_element_desc);
663: IF l_chunksize IS NOT NULL THEN
664: IF l_chunksize < l_amount THEN
665: l_amount := (l_amount/l_chunksize) * l_chunksize;
666: END IF;

Line 669: DBMS_LOB.READ

665: l_amount := (l_amount/l_chunksize) * l_chunksize;
666: END IF;
667: END IF;
668: IF l_element_desc IS NOT NULL THEN
669: DBMS_LOB.READ
670: (lob_loc => l_element_desc,
671: amount => l_amount,
672: offset => l_position,
673: buffer => l_buffer