This code gives me ORA-00902:
CREATE TYPE SchemaA.TypeForColumn AS OBJECT (col NUMBER); / CREATE TABLE SchemaB.ColumnDependsOnType (col SchemaA.TypeForColumn);
This very similar code doesn't:
CREATE TYPE SchemaA.TypeForColumn AS OBJECT (col NUMBER); / CREATE TABLE SchemaA.ColumnDependsOnType (col SchemaA.TypeForColumn);
I know that you can use some system types like this (e.g. ORDSYS.ORDAudio) - is it the case that you can't use custom types that are defined in other schemas, or am I doing something else wrong?
Answer by Andrew Mobbs ·
From memory, you need to create a synonym for the type in your own schema and reference that. I'll go and see if I can find some documentation.
Edit: For future reference; my recollection was incorrect, synonyms are not required. See comments.
Ah - other thing to check is that permissions are OK, and User A has permission on the type.
GRANT EXECUTE ON TypeForColumn TO UserA