No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
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 users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
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, 66 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, 66 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