loop2

CREATE OR REPLACE FUNCTION blob_chunks_count(
p_blob BLOB,
p_chunk_size NUMBER DEFAULT 100
) RETURN NUMBER IS
l_blob_len INTEGER;
BEGIN
IF p_blob IS NULL THEN
RETURN 0;
END IF;

l_blob_len := DBMS_LOB.GETLENGTH(p_blob);

-- Calculate total chunks needed (ceiling division)
RETURN CEIL(l_blob_len / p_chunk_size);
END blob_chunks_count;
/