No question at this time
DBA Top 10
1 B. Vroman 14400
2 M. Cadot 14200
3 A. Kavsek 7100
4 T. Boles 6100
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3600
7 G. Lambregts 1100
7 T. P 1100
7 P. Wisse 1100
10 B. Derous 500
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48226
Total active users1641
Act. users last 24h5
Act. users last hour0
Registered user hits last week355
Registered user hits last month1464
Go up

ORA:02070 While updating rows using DBLINK
Next thread: oracle to mysql migration
Prev thread: Sql tunning

Message Score Author Date
Hi, I am getting error ORA-02070 database MYDBL...... rahul singh Oct 09, 2017, 07:56
Hi, isn't it obvious from the error message its...... Ales Kavsek Oct 09, 2017, 09:48

Follow up by mail Click here


Subject: ORA:02070 While updating rows using DBLINK
Author: rahul singh, India
Date: Oct 09, 2017, 07:56, 286 days ago
Os info: Windows
Oracle info: 11g
Message: Hi,

I am getting error ORA-02070 database MYDBLINK does not support subqueries in this context while updating mysql DB rows using remote link.

Below is the update statement:

update "Mydb"."qr_sl_booking"@MYDBLINK set "is_test"=1
where "master_code_number" in (select
"master_code_number"
from "metro_db"."qr_mas_booking"@MYDBLINK
where "is_test"=1 AND "phone"='123');

Can anyone tell me what is the issue.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ORA:02070 While updating rows using DBLINK
Author: Ales Kavsek, Slovenia
Date: Oct 09, 2017, 09:48, 286 days ago
Message: Hi,

isn't it obvious from the error message itself?
Database doesn't support subqueries in this context" and you have a subquery in your statement.
Find a workaround, for example write a stored procedure at remote site that will do what you want to be done.

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here