title: SELECT INTO INTEGER ARRAY
body: <p>I want to assign values in a table column (column type is integer) to integer array. Unfortunately I could not.</p>
  
  <p>--TYPE--</p>
  
  <pre><code>CREATE OR REPLACE TYPE ABILITY_ID_ARRAY IS VARRAY(100) OF INTEGER
  </code></pre>
  
  <p>--DECLARE IN PROCEDURE</p>
  
  <pre><code>ABILITY_IDS ABILITY_ID_ARRAY;
  </code></pre>
  
  <p>--STATEMENT--</p>
  
  <pre><code>SELECT ABILITY_FK INTO ABILITY_IDS 
  FROM T_EDUCATION_ABILITY_REL 
  WHERE EDUCATION_FK = edu_id;
  </code></pre>
  
  <p>I received this error: </p>
  
  <blockquote>
    <p>[Error] ORA-00932 (16: 12): PL/SQL: ORA-00932: inconsistent datatypes: expected UDT got NUMBER</p>
  </blockquote>