No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48052
Total active users1733
Act. users last 24h10
Act. users last hour1
Registered user hits last week395
Registered user hits last month1204
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, 8 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, 8 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