3 Replies Latest reply: Aug 7, 2013 9:03 AM by gaverill RSS

    How to access A user object from B user

    govindaraju19

      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 );

      /