title: How do I create Oracle Type which refers to table columns for data type?
body: <p>I am trying to define a <code>type</code> using the following code.</p>
  
  <pre><code>CREATE OR REPLACE TYPE MY_TYPE AS OBJECT (
      app_id        some_table_name.app_id%type
  );
  </code></pre>
  
  <p>If I run this, I get the error.</p>
  
  <pre><code>Error(4,32): PLS-00201: identifier 'some_table_name.app_id' must be declared
  </code></pre>
  
  <p>What is wrong with this?</p>