sql script hangs in SQLplus on Solaris
Running an sql script in SQLplus on Solaris
Any idea why script hangs in line 9 '/' and not executed?
declare
dummy number;
begin
select 1
into dummy from dual ;
end;
/
sqlplus solaris
asked Nov 20 '14 at 14:21
lagioslagios
11
add a comment |
Running an sql script in SQLplus on Solaris
Any idea why script hangs in line 9 '/' and not executed?
declare
dummy number;
begin
select 1
into dummy from dual ;
end;
/
sqlplus solaris
asked Nov 20 '14 at 14:21
lagioslagios
11
add a comment |
Running an sql script in SQLplus on Solaris
Any idea why script hangs in line 9 '/' and not executed?
declare
dummy number;
begin
select 1
into dummy from dual ;
end;
/
sqlplus solaris
asked Nov 20 '14 at 14:21
lagioslagios
11
Running an sql script in SQLplus on Solaris
Any idea why script hangs in line 9 '/' and not executed?
declare
dummy number;
begin
select 1
into dummy from dual ;
end;
/
sqlplus solaris
sqlplus solaris
asked Nov 20 '14 at 14:21
lagioslagios
11
asked Nov 20 '14 at 14:21
lagioslagios
11
asked Nov 20 '14 at 14:21
lagioslagios
11
asked Nov 20 '14 at 14:21
lagioslagios
11
asked Nov 20 '14 at 14:21
lagioslagios
11
11
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
May be due to invisible characters, which could come from a wrong FTP copy.
Maybe because you don't have a newline after the last slash ?
Try removing empty lines inside the complete PL/SQL block.
answered Dec 6 '14 at 19:47
tvCatvCa
1476
add a comment |
Have you committed or rolled back the transaction? It seems like transaction isn't committed.
You just need to either add an exit at the end of the script, or run it as sqlplus username/password@server/dbname < Setup.sql (i.e. redirected input, < instead of @).
You can check if that's the issue by just typing 'exit' in the hanging session.
answered 57 mins ago
CR241CR241
798319
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f83162%2fsql-script-hangs-in-sqlplus-on-solaris%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
May be due to invisible characters, which could come from a wrong FTP copy.
Maybe because you don't have a newline after the last slash ?
Try removing empty lines inside the complete PL/SQL block.
answered Dec 6 '14 at 19:47
tvCatvCa
1476
add a comment |
May be due to invisible characters, which could come from a wrong FTP copy.
Maybe because you don't have a newline after the last slash ?
Try removing empty lines inside the complete PL/SQL block.
answered Dec 6 '14 at 19:47
tvCatvCa
1476
add a comment |
May be due to invisible characters, which could come from a wrong FTP copy.
Maybe because you don't have a newline after the last slash ?
Try removing empty lines inside the complete PL/SQL block.
answered Dec 6 '14 at 19:47
tvCatvCa
1476
May be due to invisible characters, which could come from a wrong FTP copy.
Maybe because you don't have a newline after the last slash ?
Try removing empty lines inside the complete PL/SQL block.
answered Dec 6 '14 at 19:47
tvCatvCa
1476
answered Dec 6 '14 at 19:47
tvCatvCa
1476
answered Dec 6 '14 at 19:47
tvCatvCa
1476
answered Dec 6 '14 at 19:47
tvCatvCa
1476
1476
add a comment |
add a comment |
Have you committed or rolled back the transaction? It seems like transaction isn't committed.
You just need to either add an exit at the end of the script, or run it as sqlplus username/password@server/dbname < Setup.sql (i.e. redirected input, < instead of @).
You can check if that's the issue by just typing 'exit' in the hanging session.
answered 57 mins ago
CR241CR241
798319
add a comment |
Have you committed or rolled back the transaction? It seems like transaction isn't committed.
You just need to either add an exit at the end of the script, or run it as sqlplus username/password@server/dbname < Setup.sql (i.e. redirected input, < instead of @).
You can check if that's the issue by just typing 'exit' in the hanging session.
answered 57 mins ago
CR241CR241
798319
add a comment |
Have you committed or rolled back the transaction? It seems like transaction isn't committed.
You just need to either add an exit at the end of the script, or run it as sqlplus username/password@server/dbname < Setup.sql (i.e. redirected input, < instead of @).
You can check if that's the issue by just typing 'exit' in the hanging session.
answered 57 mins ago
CR241CR241
798319
Have you committed or rolled back the transaction? It seems like transaction isn't committed.
You just need to either add an exit at the end of the script, or run it as sqlplus username/password@server/dbname < Setup.sql (i.e. redirected input, < instead of @).
You can check if that's the issue by just typing 'exit' in the hanging session.
answered 57 mins ago
CR241CR241
798319
answered 57 mins ago
CR241CR241
798319
answered 57 mins ago
CR241CR241
798319
answered 57 mins ago
CR241CR241
798319
798319
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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.
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%2fdba.stackexchange.com%2fquestions%2f83162%2fsql-script-hangs-in-sqlplus-on-solaris%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
