Oracle-lost rpc connection to heterogeneous remote agent using sid
0
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 '18 at 10:53
a_horse_with_no_name
302k46463557
asked Nov 21 '18 at 10:14
ktaroktaro
14410
|
show 2 more comments
0
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 '18 at 10:53
a_horse_with_no_name
302k46463557
asked Nov 21 '18 at 10:14
ktaroktaro
14410
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 '18 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 '18 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 '18 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 '18 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 '18 at 6:01
|
show 2 more comments
0
0
0
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 '18 at 10:53
a_horse_with_no_name
302k46463557
asked Nov 21 '18 at 10:14
ktaroktaro
14410
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 '18 at 10:53
a_horse_with_no_name
302k46463557
asked Nov 21 '18 at 10:14
ktaroktaro
14410
edited Nov 21 '18 at 10:53
a_horse_with_no_name
302k46463557
asked Nov 21 '18 at 10:14
ktaroktaro
14410
edited Nov 21 '18 at 10:53
a_horse_with_no_name
302k46463557
edited Nov 21 '18 at 10:53
a_horse_with_no_name
302k46463557
edited Nov 21 '18 at 10:53
a_horse_with_no_name
302k46463557
302k46463557
asked Nov 21 '18 at 10:14
ktaroktaro
14410
asked Nov 21 '18 at 10:14
ktaroktaro
14410
asked Nov 21 '18 at 10:14
ktaroktaro
14410
14410
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 at 6:01
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 '18 at 11:23
Did dblink work before this error? Or is it a mistake after creating a new dblink?
– Dmitry Demin
Nov 21 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 at 6:01
|
show 2 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
0
active
oldest
votes
0
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.
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 '18 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 '18 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 '18 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 '18 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 '18 at 6:01