Re: ora-02070 Remote Update over dblink

From: <douglab1_at_my-dejanews.com>
Date: Mon, 22 Mar 1999 21:08:42 GMT
Message-ID: <7d6bgi$9hi$1@nnrp1.dejanews.com>

We've run across this problem (or a similar one) when we connect to an AS/400 through a db link. What we found is Oracle has to be able to process the SQL statement in a single location. Oracle can't do that with the the correlated subquery table being local and the update table being remote.

Brad Douglass

In article <36F67105.B55D43F4_at_hotmail.com>, Sameer Utrankar <Utrankar_at_hotmail.com> wrote:
> 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.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 22 1999 - 15:08:42 CST