title: oracle column not allowed here
body: <p>I got this error:</p>
  
  <pre><code>Error report -
  ORA-00984: column not allowed here
  ORA-06512: at line 14
  00984. 00000 -  "column not allowed here"
  </code></pre>
  
  <p>here is the code. I copy and paste the field name (all in cap). The field name should be correct</p>
  
  <pre><code>set serveroutput on
  
  DECLARE
    my_creation_dt date;
    mysql varchar2(6000) := '';
  BEGIN
    select creation_dt into my_creation_dt from role_table where security_role = 'admin';
  
    mysql := 'insert into role_grant_table (PERSON_ID, CREATION_DT, SECURITY_ROLE, 
      SSS_CREATE_DT, UPDATE_WHO, UPDATE_ON) values (1234, SYSDATE, 
      "ADMIN", 
      :my_creation_dt, 
      "myname", 
      SYSDATE)'; -- line 14, column not allowed here
  
    execute immediate mysql using (my_creation_dt);
  
  END;
  </code></pre>