DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on DBMS_LOB

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

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

Line 671: DBMS_LOB.READ

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