I have a type in the package

type test_rec is record( mm Test.mm%type );

Now you need to create a global object to use it in several packages:

 CREATE OR REPLACE TYPE test_rec is OBJECT ( mm Test.mm%type )

I get the error: Error: PLS-00201: identifier 'Test.mm' must be declared

    1 answer 1

    %type , like %rowtype , is the syntax of PL / SQL. Not supported in SQL. Therefore, in short, it is impossible to create a full-fledged (and not inside the package) type that refers to the type of a specific column in a table or the entire set of columns of a table. Unfortunately.