DBA Data[Home] [Help]

APPS.PO_COMM_FPDSNG_PVT dependencies on UTL_RAW

Line 1001: l_Buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( p_ClobData, 16000, l_DataSize ) );

997:
998: l_progress := '002';
999: LOOP
1000: l_progress := '003';
1001: l_Buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( p_ClobData, 16000, l_DataSize ) );
1002:
1003: IF UTL_RAW.LENGTH( l_Buffer ) > 0 THEN
1004: DBMS_LOB.writeAppend( l_TempBLOB, UTL_RAW.LENGTH( l_Buffer ), l_Buffer );
1005: END IF;

Line 1003: IF UTL_RAW.LENGTH( l_Buffer ) > 0 THEN

999: LOOP
1000: l_progress := '003';
1001: l_Buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( p_ClobData, 16000, l_DataSize ) );
1002:
1003: IF UTL_RAW.LENGTH( l_Buffer ) > 0 THEN
1004: DBMS_LOB.writeAppend( l_TempBLOB, UTL_RAW.LENGTH( l_Buffer ), l_Buffer );
1005: END IF;
1006:
1007: l_DataSize := l_DataSize + 16000;

Line 1004: DBMS_LOB.writeAppend( l_TempBLOB, UTL_RAW.LENGTH( l_Buffer ), l_Buffer );

1000: l_progress := '003';
1001: l_Buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( p_ClobData, 16000, l_DataSize ) );
1002:
1003: IF UTL_RAW.LENGTH( l_Buffer ) > 0 THEN
1004: DBMS_LOB.writeAppend( l_TempBLOB, UTL_RAW.LENGTH( l_Buffer ), l_Buffer );
1005: END IF;
1006:
1007: l_DataSize := l_DataSize + 16000;
1008: EXIT WHEN l_DataSize > l_BLOBLength;

Line 1042: l_TempChar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_BlobData, l_Buffer, l_Start));

1038: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_BlobData) / l_Buffer)
1039: LOOP
1040:
1041: l_progress := '002';
1042: l_TempChar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_BlobData, l_Buffer, l_Start));
1043:
1044: DBMS_LOB.WRITEAPPEND(l_CLOBData, LENGTH(l_TempChar), l_TempChar);
1045:
1046: l_Start := l_Start + l_Buffer;