Ora-02070
From: Frank Bucher <frankbucher_at_gmx.de>
Date: 3 Sep 2001 00:20:09 -0700
Message-ID: <f742146.0109022320.483e0062_at_posting.google.com>
Date: 3 Sep 2001 00:20:09 -0700
Message-ID: <f742146.0109022320.483e0062_at_posting.google.com>
Hi all,
we've got a problem here. It happens when we try to update a database with values from another. But we get an ORA-02070 (database db1 does not support operator PLSFUN in this context). I've done little research on the net, but didn't anything suitable. Here is the statement:
INSERT INTO t1_at_db1(PK, FAID, BEGRIFF) SELECT GetPK_at_db1('t1'), t.FAID, t.BEGRIFF FROM (select distinct faid, begriff from t1) t
If I execute the select-statement per se anything works fine. The local database is 8.0.5 and the remote db is 8.1.7. Both on an AIX machine.
Any help appreciated. You could also mail me: frankbucher_at_gmx.de
TIA
Frank.
Received on Mon Sep 03 2001 - 09:20:09 CEST