Pls-00329

From: TrynTry <TrynTry.1w7g6s_at_no-mx.forums.yourdomain.com.au>
Date: Sat, 1 Oct 2005 04:47:34 +0200
Message-ID: <TrynTry.1w7g6s_at_no-mx.forums.yourdomain.com.au>

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

Received on Sat Oct 01 2005 - 04:47:34 CEST