sql script hangs in SQLplus on SolarisInvalid File Name on login to SQLPLUSHow do I execute an Oracle SQL...
What Happens when Passenger Refuses to Fly Boeing 737 Max?
How does Dispel Magic work against Stoneskin?
What to do when during a meeting client people start to fight (even physically) with each others?
what does the apostrophe mean in this notation?
Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?
Can you reject a postdoc offer after the PI has paid a large sum for flights/accommodation for your visit?
What is the dot in “1.2.4."
Good allowance savings plan?
Rejected in 4th interview round citing insufficient years of experience
What wound would be of little consequence to a biped but terrible for a quadruped?
Format picture and text with TikZ and minipage
Counter-example to the existence of left Bousfield localization of combinatorial model category
Is all copper pipe pretty much the same?
Question about partial fractions with irreducible quadratic factors
Gravity alteration as extermination tool viable?
Why would a jet engine that runs at temps excess of 2000°C burn when it crashes?
Is having access to past exams cheating and, if yes, could it be proven just by a good grade?
Does Linux have system calls to access all the features of the file systems it supports?
Who is our nearest neighbor
infinitive telling the purpose
Life insurance that covers only simultaneous/dual deaths
Am I not good enough for you?
How is the Swiss post e-voting system supposed to work, and how was it wrong?
Is going from continuous data to categorical always wrong?
sql script hangs in SQLplus on Solaris
Invalid File Name on login to SQLPLUSHow do I execute an Oracle SQL script without sqlplus hanging on me?sqlplus consuming 99% CPUexecute .sql script inside an anonymous pl/sql block which is invoked by a shell scriptSQLPlus “no listener” only with a remote connection from WindowsConditional flow in sqlplusORA-01017: invalid username/password; logon denied from sql developer but sqlplus loginsHow to preserve sqlplus session in shell scriptSet TERMOUT OFF is not working when I am using sqlplus in command prompt?Spool query output to file (SQLPlus)
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
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
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
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
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
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
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 |
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
1 Answer
1
active
oldest
votes
1 Answer
1
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 |
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
