full text

FOR rec IN (
    SELECT 
        blob_to_text_range(t.VERSIONS, c.start_byte, c.end_byte) as chunk_content
    FROM CacheIOIStates t
    CROSS JOIN (
        SELECT 
            level as chunk_num,
            (level * 4000 - 3999) as start_byte,
            (level * 4000) as end_byte
        FROM dual 
        CONNECT BY level <= CEIL(
            (SELECT blob_length(VERSIONS) FROM CacheIOIStates WHERE IOIID = p_key1) / 4000
        )
    ) c
    WHERE t.IOIID = p_key1
    ORDER BY c.chunk_num
) LOOP
    IF rec.chunk_content IS NOT NULL THEN
        DBMS_OUTPUT.PUT_LINE(rec.chunk_content);
    END IF;
END LOOP;