Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t_taböe (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 t_taböe (name, type)
         VALUES(l_stuff.get(i), 'TEXT');
   END LOOP;
END;
/
ORA-06550: line 9, column 29:
PL/SQL: ORA-00984: column not allowed here
ORA-06550: line 8, column 9:
PL/SQL: SQL Statement ignored

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 t_taböe (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 8

DECLARE
   l_stuff        json_array_t;
   l_name         t_taböe.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 t_taböe (name, type)
      VALUES(l_name, 'TEXT');
   END LOOP;
END;
/
1 rows affected

select * from t_taböe;


NAME
TYPE


Stirfry
TEXT

Yogurt
TEXT

Apple
TEXT