title: Could %type be used with Object type? Is it possible because I am getting error while trying to do so
body: <p>I am trying to use %type with object type</p>
  <p>for eg ,</p>
  <h2><em><strong>Method 1:</strong></em></h2>
  <pre><code>  CREATE TYPE emp_object AS OBJECT(
      i_Emp_id Employee_table.emp_id%type,
      i_Emp_name  Employee_table.emp_name%type
      i_salary  Employee.salary%type);
  </code></pre>
  <p><strong>But I am unable to create object type as in the method 1...</strong></p>
  <p>I am able to create object type by using method 2, but this has some functionality issue when I use it in my application as mentioned below..</p>
  <h2><em><strong>Method 2:</strong></em></h2>
  <pre><code> CREATE TYPE emp_object AS OBJECT( i_Emp_id number, i_Emp_name  varchar2(10), i_Salary Number(13,9));
  </code></pre>
  <p><em>The problem which i am facing with the second method is that, when ever I change the precision of the data type in Salary column in the table, I have to change drop the object type and recreate it. Also I have to change the code in the API and UI.. This could be surely avoided if I can use the %type while creating the object type. But I am unable to do so because Oracle throws error. Is there a way to apply %type for object type columns.. Please help me...I tried everything but I am facing this blocker for along time...</em></p>