This discussion is archived
3 Replies Latest reply: Aug 7, 2013 7:03 AM by gaverill RSS

How to access A user object from B user

govindaraju19 Newbie
Currently Being Moderated

Our project, we are creating object on Schema_A. How to access the same object from Schema_B

except creating sub_type from Schema_B. Please provide any suggestions to access the Schema_A object

from Schema_B.

 

Schema_A:

CREATE OR REPLACE

TYPE CUSTOMER_UPDATE_REC AS OBJECT (

  CUSTOMER_ID       NUMBER(16),

  ADDR_TYPE           VARCHAR2(20),

  TOWN                    VARCHAR2(40),

  PCODE                  VARCHAR2(10),

  COUNTRY              VARCHAR2(20), 

  PH_NBR                VARCHAR2(15)

);

/

 

CREATE OR REPLACE TYPE CUSTOMER_UPDATE_TAB IS TABLE OF CUSTOMER_UPDATE_REC;

/

 

GRANT EXECUTE ON CUSTOMER_UPDATE_TAB TO schema_b;

/

 

Schema_B:

CREATE TYPE CUSTOMER_UPDATE_TAB AS OBJECT ( attr3 Schema_A.CUSTOMER_UPDATE_TAB );

/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points