This discussion is archived
8 Replies Latest reply: Feb 22, 2013 9:27 AM by user9077483 RSS

Inserting data using DBLINK.

user9077483 Newbie
Currently Being Moderated
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.

Legend

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