DBA Data[Home] [Help]

APPS.PER_NL_LTSR_ARCHIVE dependencies on UTL_RAW

Line 22: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );

18: -- hr_utility.trace('+====c2b===================================================+');
19: dbms_lob.createtemporary(res,TRUE);
20: dbms_lob.open(res,dbms_lob.lob_readwrite);
21: LOOP
22: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
23: IF utl_raw.length( buffer ) > 0 THEN
24: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
25: END IF;
26: pos := pos + 16000;

Line 23: IF utl_raw.length( buffer ) > 0 THEN

19: dbms_lob.createtemporary(res,TRUE);
20: dbms_lob.open(res,dbms_lob.lob_readwrite);
21: LOOP
22: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
23: IF utl_raw.length( buffer ) > 0 THEN
24: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
25: END IF;
26: pos := pos + 16000;
27: EXIT WHEN pos > lob_len;

Line 24: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);

20: dbms_lob.open(res,dbms_lob.lob_readwrite);
21: LOOP
22: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
23: IF utl_raw.length( buffer ) > 0 THEN
24: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
25: END IF;
26: pos := pos + 16000;
27: EXIT WHEN pos > lob_len;
28: END LOOP;