Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tab (name varchar2(30), type varchar2(30));
DECLARE
    l_stuff json_array_t;
BEGIN
    l_stuff := json_array_t ('["Stirfry", "Yogurt", "Apple"] ');  
    FOR indx IN 0 .. (l_stuff.get_size - 1) LOOP
        INSERT INTO tab (name, type) VALUES (l_stuff.get_string(indx), 'TEXT');
   END LOOP;
END;
/
ORA-40573: Invalid use of PL/SQL JSON object type.
ORA-06512: at line 6

DECLARE
    l_stuff json_array_t;
    l_name  tab.name%type;
BEGIN
    l_stuff := json_array_t ('["Stirfry", "Yogurt", "Apple"] ');  
    FOR indx IN 0 .. (l_stuff.get_size - 1) LOOP
        -- assigfn to variable - bug 28901431 
        l_name := l_stuff.get_string(indx);
        INSERT INTO tab (name, type) VALUES (l_name, 'TEXT');
   END LOOP;
END;
/
1 rows affected

select * from tab;


NAME
TYPE


Stirfry
TEXT

Yogurt
TEXT

Apple
TEXT