ora-02070 Remote Update over dblink

From: Sameer Utrankar <Utrankar_at_hotmail.com>
Date: Mon, 22 Mar 1999 11:34:13 -0500
Message-ID: <36F67105.B55D43F4@hotmail.com>

pl*sql proc performing remote db update over dblink gets the following error.
Does anyone know what causes this error or what this means ? What is operator 105 ?

02070, 00000, "database %s%s does not support %s in this context"
// *Cause: The remote database does not support the named capability in
// the context in which it is used.
// *Action: Simplify the SQL statement.
//

Stmt is as follows:
The table being updated (carat_customer_control is a remote table - there is no @dblink in it
because that's a local synonym pointing to remote table). Subquery (exists) is on a local table.
IF SUBQUERY IS REMOVED, ERROR DISAPPERAS so there is a workaround but still
interested in finding out what this error is !!!

      UPDATE CARAT_CUSTOMER_CONTROL X
      SET    X.IMPORT_CONTROL = 'N'
            ,X.IMPORT_DT = SYSDATE
            ,X.IMPORT_MESSAGE = 'CUSTOMER NOT PROCESSED. Please see

report for C
oncurrent Request : '

      WHERE  EXISTS (SELECT NULL
                     FROM   RA_CUSTOMERS_INTERFACE Y
                     WHERE  Y.CUSTOMER_ATTRIBUTE10 = X.ID)
      AND X.IMPORT_CONTROL = 'I'
      AND X.RECORD_TYPE = 'C'

/

ERROR at line 10:
ORA-02070: database IBKMUNIU1 does not support operator 105 in this context

02070, 00000, "database %s%s does not support %s in this context"
// *Cause: The remote database does not support the named capability in
// the context in which it is used.
// *Action: Simplify the SQL statement.
Received on Mon Mar 22 1999 - 10:34:13 CST