Pls-00329

[TrynTry]

I am trying to create a TYPE table in schema scott with rowtype of a
table in schema matt as below:

CREATE TYPE tst_typ is TABLE of matt.ordertable%ROWTYPE;

I keep getting the error:
LINE/COL ERROR
--------
-----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/32 PLS-00329: schema-level type has illegal reference to
MATT.ORDERTABLE

What am I doing wrong or what kind of privileges are missing?
I have ensured that there is reference entry in dba_tab_privs to the
table for the schema SCOTT

GRANTEE OWNER
------------------------------ ------------------------------
TABLE_NAME GRANTOR
------------------------------ ------------------------------
PRIVILEGE GRA HIE
---------------------------------------- --- ---

SCOTT MATT ORDERTABLE MATT REFERENCES
YES NO


--
TrynTry
------------------------------------------------------------------------
TrynTry's Profile: http://www.highdots.com/forums/m872
View this thread: http://www.highdots.com/forums/t3002413