DBA Data[Home] [Help]

APPS.HR_H2PI_DOWNLOAD dependencies on DBMS_LOB

Line 270: l_cloblength := dbms_lob.getlength(p_clob_to_write);

266: l_proc varchar2(72) := g_package || 'write' ;
267:
268: begin
269: hr_utility.set_location('Entering:' || l_proc,10);
270: l_cloblength := dbms_lob.getlength(p_clob_to_write);
271: l_offset := 0;
272: l_new_position := 0;
273: loop
274: l_string := dbms_lob.substr(p_clob_to_write,l_lengthtoread, l_offset + 1);

Line 274: l_string := dbms_lob.substr(p_clob_to_write,l_lengthtoread, l_offset + 1);

270: l_cloblength := dbms_lob.getlength(p_clob_to_write);
271: l_offset := 0;
272: l_new_position := 0;
273: loop
274: l_string := dbms_lob.substr(p_clob_to_write,l_lengthtoread, l_offset + 1);
275: if length(l_string) > 32766 then
276: l_new_position := instr(l_string,'',-1)+ 5;
277: l_string := substr(l_string,1,l_new_position);
278: else