title: How to resolve ORA-00984 when using SQL in EXECUTE IMMEDIATE?
body: <p>I'm trying to store a lsit of predefined Oracle database administrative user accounts to a table <em>DBOMIT_SCHEMAS</em> using a list <em>schema_list</em> as in code. </p>
  
  <pre><code>DECLARE
    TYPE schema_list_type IS TABLE OF "DBCONTROL"."DBSCHEMA_INFO".SCHEMA%TYPE;
    schema_list schema_list_type;
  BEGIN
    schema_list := schema_list_type('ANONYMOUS', 'CTXSYS', 'DBSNMP', 'EXFSYS', 'LBACSYS', 'MDSYS', 'MGMT_VIEW','OLAPSYS', 'OWBSYS', 'ORDPLUGINS', 'ORDSYS', 'OUTLN', 'SI_INFORMTN_SCHEMA', 'SYS', 'SYSMAN', 'SYSTEM', 'TSMSYS', 'WK_TEST', 'WKSYS', 'WKPROXY', 'WMSYS', 'XDB');
  
    FOR i IN schema_list.FIRST .. schema_list.LAST
    LOOP
      DBMS_OUTPUT.PUT_LINE('***DEBUG***: '||schema_list(i));
      EXECUTE IMMEDIATE('INSERT INTO "DBCONTROL"."DBOMIT_SCHEMAS" VALUES('||schema_list(i)||')');
    END LOOP;
  
  END;
  </code></pre>
  
  <p>When I'm trying to loop through the list and insert each value to the table, I get <strong>ORA-00984: column not allowed here</strong> error. I guess, this happens because it understands ANONYMOUS (column name) instead of 'ANONYMOUS' (String). Could anyone please  resolve this.</p>