PLS-00329: schema-level type has illegal reference to
457764Oct 2 2005 — edited Oct 2 2005I am trying to create a PL/SQL Package which needs a table type which needs to be defined at schema level. The type refers to a table across another schema.
I am getting an error as below when I try to create the Type. What is wrong?
My DBA provided me reference access which I see in the dba_tab_privs table as below. Is there some other privilege which is still missing please help.
READ SCOTT ORDERLINES SCOTT REFERENCES YES NO
CREATE TYPE type_tab is TABLE of scott.orderlines%ROWTYPE;
Warning: Type created with compilation errors.
show errors;
Errors for TYPE TEST_TAB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/32 PLS-00329: schema-level type has illegal reference to
BAAN.TTDSLS401100