title: PL/SQL PLS-00208: identifier 'TYPE' is not a legal cursor attribute
body: <p><strong>What I am trying to do</strong></p>
  
  <p>I am trying to write a procedure that creates a table using <a href="https://docs.oracle.com/cloud/latest/db112/LNPLS/dynamic.htm#LNPLS011" rel="nofollow noreferrer">Dynamic SQL</a>.</p>
  
  <p><strong>What is the problem</strong></p>
  
  <p>I get the following error while compiling the procedure:</p>
  
  <pre><code>LINE/COL ERROR
  -------- -----------------------------------------------------------------
  4/5      PL/SQL: Statement ignored
  4/80     PLS-00208: identifier 'TYPE' is not a legal cursor attribute
  </code></pre>
  
  <p><strong>Procedure:</strong></p>
  
  <pre><code>create or replace procedure createTab is
  
      begin
          EXECUTE IMMEDIATE 'create table thisYearCustomerNames (id ' || customer.id%type || ', name ' ||
                                                                 customer.name%type || ', points ' ||
                                                                 customer.points%type || ')';
      end;
      /
  </code></pre>
  
  <p><strong>Customer Table</strong></p>
  
  <pre><code>Name               Null?      Type
   -----------------------------------------
   ID                NOT NULL   NUMBER(5)
   NAME                         VARCHAR2(30)
   ADDRESS                      VARCHAR2(40)
   POINTS            NOT NULL   NUMBER(10)
   DATE_OF_JOINING              DATE
   GENDER                       CHAR(1)
  </code></pre>