How to give a field of an object the same type as a column of a table?

Question

I would like to a object with a field that has the same type as column of a table.

create table TA (  
  TA_1          number
);

CREATE TYPE my_obj2 IS object
(
    TA_1            TA.TA_1%type
);
    

ORA-24344: success with compilation error

Is it possible. If yes, what is wrong in this code?

code

Answer 1

You can't do that.

The CREATE TYPE document states:

This data type must be stored in the database; that is, either a predefined data type or a user-defined standalone collection type.