DBA Data[Home] [Help]

APPS.FND_SEED_STAGE_UTIL dependencies on DBMS_LOB

Line 140: DBMS_LOB.READ(l_upload_lob, l_amt, l_offset, l_buffer);

136: l_offset := 1;
137: BEGIN
138: LOOP
139: l_amt := 32767;
140: DBMS_LOB.READ(l_upload_lob, l_amt, l_offset, l_buffer);
141: l_upload_stmt := l_upload_stmt||l_buffer;
142: l_offset := l_offset + l_amt;
143: END LOOP;
144: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 154: DBMS_LOB.READ(l_upload_lob, l_amt, l_offset, l_upload_arr(l_read_cnt));

150: l_read_cnt := 1;
151: BEGIN
152: LOOP
153: l_amt := 256;
154: DBMS_LOB.READ(l_upload_lob, l_amt, l_offset, l_upload_arr(l_read_cnt));
155: l_offset := l_offset + l_amt;
156: l_read_cnt := l_read_cnt + 1;
157: END LOOP;
158: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 235: dbms_lob.createtemporary(p_temp_clob,true,dbms_lob.session);

231:
232: PROCEDURE create_temp_clob(p_temp_clob IN OUT NOCOPY CLOB)
233: is
234: begin
235: dbms_lob.createtemporary(p_temp_clob,true,dbms_lob.session);
236: end;
237:
238: end FND_SEED_STAGE_UTIL;