DBA Data[Home] [Help]

APPS.FND_SEED_STAGE_UTIL dependencies on DBMS_LOB

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

151: l_offset := 1;
152: BEGIN
153: LOOP
154: l_amt := 32767;
155: DBMS_LOB.READ(l_upload_lob, l_amt, l_offset, l_buffer);
156: l_upload_stmt := l_upload_stmt||l_buffer;
157: l_offset := l_offset + l_amt;
158: END LOOP;
159: EXCEPTION WHEN NO_DATA_FOUND THEN

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

165: l_read_cnt := 1;
166: BEGIN
167: LOOP
168: l_amt := 256;
169: DBMS_LOB.READ(l_upload_lob, l_amt, l_offset, l_upload_arr(l_read_cnt));
170: l_offset := l_offset + l_amt;
171: l_read_cnt := l_read_cnt + 1;
172: END LOOP;
173: EXCEPTION WHEN NO_DATA_FOUND THEN

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

246:
247: PROCEDURE create_temp_clob(p_temp_clob IN OUT NOCOPY CLOB)
248: is
249: begin
250: dbms_lob.createtemporary(p_temp_clob,true,dbms_lob.session);
251: end;
252:
253: end FND_SEED_STAGE_UTIL;