title: How to resolve the component must be declared using oracle Types
body: <p>I have two oracle types like </p>
  
  <pre><code>create or replace 
  TYPE T_EMPLOYEE 
  AS TABLE OF O_EMPLOYEE;
  </code></pre>
  
  <p>And my O_EMPLOYEE TYPE is</p>
  
  <pre><code>create or replace 
  TYPE O_EMPLOYEE
  AS OBJECT 
     (
        EMP_NAME                        VARCHAR2(50),
        EMP_ID                          VARCHAR2(50),
        EMP_DES             VARCHAR2(50)
  
      );
  </code></pre>
  
  <p>I am using this as an input in a store procedure where i need to check for the validation of name,id and designation. Using following i can convert the table in a select statement.</p>
  
  <pre><code>TABLE(CAST( I_T_EMPLOYEE AS T_EMPLOYEE)) emp,
  </code></pre>
  
  <p>but I tried to read the value like like T_EMPLOYEE.EMP_NAME, it is saying componenet EMP_NAME must be decalred.</p>
  
  <p>can any one help?</p>