Oracle-lost rpc connection to heterogeneous remote agent using sid
up vote
0
down vote
favorite
Im trying to select in plsql using dblink connected to mysql.
Here is my query:
select
t1."header_id" header_id
from
"table1"@times t1
,"table2"@times t2
where
t1."processed" = 'no'
and
t1."returned" = 'yes'
and
t2."header_id" is null
and
t1."header_id" = t2."header_id"(+)
;
This is the error:
Please help.Thank you.
oracle dblink
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
asked Nov 21 at 10:14
ktaro
707
|
show 2 more comments
up vote
0
down vote
favorite
Im trying to select in plsql using dblink connected to mysql.
Here is my query:
select
t1."header_id" header_id
from
"table1"@times t1
,"table2"@times t2
where
t1."processed" = 'no'
and
t1."returned" = 'yes'
and
t2."header_id" is null
and
t1."header_id" = t2."header_id"(+)
;
This is the error:
Please help.Thank you.
oracle dblink
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
asked Nov 21 at 10:14
ktaro
707
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 at 11:23
Yes its working. I tried to Select from single table Select * from "table1"@times and it works. But when I tried joining tables like the code above, I got an error.
– ktaro
Nov 22 at 3:44
Try to create a view in mysql and join table in mysql, and create sql for view.t1."header_id" = t2."header_id"(+)this is syntax oracle, not mysql.
– Dmitry Demin
Nov 22 at 3:56
I got your point. But that is not I want to do. I dont want to use a mysql view. I just need to run the query above.
– ktaro
Nov 22 at 5:05
Try this SQLselect t1."header_id" header_id from "table1"@times t1 LEFT outer JOIN "table2"@times t2 ON (t1."header_id" = t2."header_id") where t1."processed" = 'no' and t1."returned" = 'yes' and t2."header_id" is null ;
– Dmitry Demin
Nov 22 at 6:01
|
show 2 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Im trying to select in plsql using dblink connected to mysql.
Here is my query:
select
t1."header_id" header_id
from
"table1"@times t1
,"table2"@times t2
where
t1."processed" = 'no'
and
t1."returned" = 'yes'
and
t2."header_id" is null
and
t1."header_id" = t2."header_id"(+)
;
This is the error:
Please help.Thank you.
oracle dblink
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
asked Nov 21 at 10:14
ktaro
707
Im trying to select in plsql using dblink connected to mysql.
Here is my query:
select
t1."header_id" header_id
from
"table1"@times t1
,"table2"@times t2
where
t1."processed" = 'no'
and
t1."returned" = 'yes'
and
t2."header_id" is null
and
t1."header_id" = t2."header_id"(+)
;
This is the error:
Please help.Thank you.
oracle dblink
oracle dblink
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
asked Nov 21 at 10:14
ktaro
707
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
asked Nov 21 at 10:14
ktaro
707
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
edited Nov 21 at 10:53
a_horse_with_no_name
287k46434529
287k46434529
asked Nov 21 at 10:14
ktaro
707
asked Nov 21 at 10:14
ktaro
707
asked Nov 21 at 10:14
ktaro
707
707
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 at 11:23
Yes its working. I tried to Select from single table Select * from "table1"@times and it works. But when I tried joining tables like the code above, I got an error.
– ktaro
Nov 22 at 3:44
Try to create a view in mysql and join table in mysql, and create sql for view.t1."header_id" = t2."header_id"(+)this is syntax oracle, not mysql.
– Dmitry Demin
Nov 22 at 3:56
I got your point. But that is not I want to do. I dont want to use a mysql view. I just need to run the query above.
– ktaro
Nov 22 at 5:05
Try this SQLselect t1."header_id" header_id from "table1"@times t1 LEFT outer JOIN "table2"@times t2 ON (t1."header_id" = t2."header_id") where t1."processed" = 'no' and t1."returned" = 'yes' and t2."header_id" is null ;
– Dmitry Demin
Nov 22 at 6:01
|
show 2 more comments
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 at 11:23
Yes its working. I tried to Select from single table Select * from "table1"@times and it works. But when I tried joining tables like the code above, I got an error.
– ktaro
Nov 22 at 3:44
Try to create a view in mysql and join table in mysql, and create sql for view.t1."header_id" = t2."header_id"(+)this is syntax oracle, not mysql.
– Dmitry Demin
Nov 22 at 3:56
I got your point. But that is not I want to do. I dont want to use a mysql view. I just need to run the query above.
– ktaro
Nov 22 at 5:05
Try this SQLselect t1."header_id" header_id from "table1"@times t1 LEFT outer JOIN "table2"@times t2 ON (t1."header_id" = t2."header_id") where t1."processed" = 'no' and t1."returned" = 'yes' and t2."header_id" is null ;
– Dmitry Demin
Nov 22 at 6:01
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 at 11:23
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 at 11:23
Yes its working. I tried to Select from single table Select * from "table1"@times and it works. But when I tried joining tables like the code above, I got an error.
– ktaro
Nov 22 at 3:44
Yes its working. I tried to Select from single table Select * from "table1"@times and it works. But when I tried joining tables like the code above, I got an error.
– ktaro
Nov 22 at 3:44
Try to create a view in mysql and join table in mysql, and create sql for view.
t1."header_id" = t2."header_id"(+) this is syntax oracle, not mysql.– Dmitry Demin
Nov 22 at 3:56
Try to create a view in mysql and join table in mysql, and create sql for view.
t1."header_id" = t2."header_id"(+) this is syntax oracle, not mysql.– Dmitry Demin
Nov 22 at 3:56
I got your point. But that is not I want to do. I dont want to use a mysql view. I just need to run the query above.
– ktaro
Nov 22 at 5:05
I got your point. But that is not I want to do. I dont want to use a mysql view. I just need to run the query above.
– ktaro
Nov 22 at 5:05
Try this SQL
select t1."header_id" header_id from "table1"@times t1 LEFT outer JOIN "table2"@times t2 ON (t1."header_id" = t2."header_id") where t1."processed" = 'no' and t1."returned" = 'yes' and t2."header_id" is null ; – Dmitry Demin
Nov 22 at 6:01
Try this SQL
select t1."header_id" header_id from "table1"@times t1 LEFT outer JOIN "table2"@times t2 ON (t1."header_id" = t2."header_id") where t1."processed" = 'no' and t1."returned" = 'yes' and t2."header_id" is null ; – Dmitry Demin
Nov 22 at 6:01
|
show 2 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53409753%2foracle-lost-rpc-connection-to-heterogeneous-remote-agent-using-sid%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 at 11:23
Yes its working. I tried to Select from single table Select * from "table1"@times and it works. But when I tried joining tables like the code above, I got an error.
– ktaro
Nov 22 at 3:44
Try to create a view in mysql and join table in mysql, and create sql for view.
t1."header_id" = t2."header_id"(+)this is syntax oracle, not mysql.– Dmitry Demin
Nov 22 at 3:56
I got your point. But that is not I want to do. I dont want to use a mysql view. I just need to run the query above.
– ktaro
Nov 22 at 5:05
Try this SQL
select t1."header_id" header_id from "table1"@times t1 LEFT outer JOIN "table2"@times t2 ON (t1."header_id" = t2."header_id") where t1."processed" = 'no' and t1."returned" = 'yes' and t2."header_id" is null ;– Dmitry Demin
Nov 22 at 6:01