OraFAQ Forum: SQL & PL/SQL » DATABSE_LINK

Home » SQL & PL/SQL » SQL & PL/SQL » DATABSE_LINK_ERROR (10.2.0.4 and 11.2.0.4)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

DATABSE_LINK_ERROR [message #570552]

Mon, 12 November 2012 04:08

tabj
Messages: 14
Registered: June 2012

Junior Member

Hi all,

I have two databases. Emample database A(11.2.0.4) , database B(10.2.0.4).

while inserting object data from database A to database B i am getting below error.

ORA-22804: remote operations not permitted on object tables or user-defined type columns.

while updating i am not getting any error.

please help me on this.

regards,
tabj

Report message to a moderator

Re: DATABSE_LINK_ERROR [message #570553 is a reply to message #570552]

Mon, 12 November 2012 04:16

Michel Cadot
Messages: 54247
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-22804: remote operations not permitted on object tables or user-defined type columns
 *Cause:  An attempt was made to perform queries or DML operations on
          remote object
          tables or on remote table columns whose type is one of object,
          REF, nested table or VARRAY.

As I said in your previous topics, on which by the way we are still waiting you feedback:

Michel Cadot wrote on Fri, 05 October 2012 17:19

Too few information...

So, Use SQL*Plus and copy and paste your session, the WHOLE session.

Michel Cadot wrote on Wed, 04 July 2012 08:17

Also, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
And always post your Oracle version, with 4 decimals.
...