DBA Data[Home] [Help]

APPS.FTE_LTL_LOADER dependencies on DBMS_LOB

Line 4404: l_size := dbms_lob.getlength(l_content);

4400: WHERE
4401: file_name = p_file_name and
4402: load_id = p_load_id;
4403:
4404: l_size := dbms_lob.getlength(l_content);
4405: data_buffer := NULL;
4406:
4407: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4408: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'File size', l_size);

Line 4414: dbms_lob.read (l_content, l_amount, l_position, temp_buffer);

4410:
4411: WHILE l_size > 0 LOOP
4412:
4413: -- read a big chunk at a time:
4414: dbms_lob.read (l_content, l_amount, l_position, temp_buffer);
4415: data_buffer := data_buffer || utl_raw.cast_to_varchar2(temp_buffer);
4416: data_buffer := replace(data_buffer, l_carriage_return, ''); -- dos2unix conversion
4417:
4418: -- Now tokenize by linefeed