1140: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1141:
1142:
1143: LOOP
1144: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
1145:
1146: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
1147: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
1148: END IF;
1142:
1143: LOOP
1144: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
1145:
1146: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
1147: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
1148: END IF;
1149:
1150: pos := pos + 16000;
1143: LOOP
1144: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
1145:
1146: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
1147: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
1148: END IF;
1149:
1150: pos := pos + 16000;
1151: EXIT WHEN pos > lob_len;