8 Replies Latest reply: Feb 22, 2013 11:31 AM by sb92075 RSS

    Inserting data using DBLINK.

    user9077483
      Hi Experts,

      I am inserting XMLTYPE data using DBLINK I am getting the following error.
      INSERT INTO APSP.SALES_HISTORY@APSP_LINK
      SELECT * FROM KMBS.SALES_HISTORY
      ORA-22804: remote operations not permitted on object tables or user-defined type columns

      Source table structure
      Name                                      Null?    Type                        
       ----------------------------------------- -------- ----------------------------
       SC_NO                                  NOT NULL NUMBER(25)                  
       LT_DATE                                         TIMESTAMP(6)                
       METHOD                                          XMLTYPE
      Target table structure(another DB)
      Name                                      Null?    Type                        
       ----------------------------------------- -------- ----------------------------
       SC_NO                                  NOT NULL NUMBER(25)                  
       LT_DATE                                         TIMESTAMP(6)                
       METHOD                                          XMLTYPE
      Please help me how to insert XMLTYPE data using DBLINK.

      Thanks in advance.