Mixing
PLS-00103: Encountered the symbol “)” when expecting one of the following: (
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am a beginner in oracle and following is my function definition and invocation part. I am unable to understand the error that I get when I call the function. Please help me rectify my code.
ORA-06550: line 4, column 56: PLS-00103: Encountered the symbol ")" when expecting one of the following: (
create or replace function totalcustomers
RETURN number
IS
total number:=0;
BEGIN
select count(*) into total from customers;
RETURN total;
END;
/
declare sum number;
BEGIN
sum := totalcustomers();
dbms_output.put_line('Total number of customers '||sum);
END;
/
oracle plsql oracle12c
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
asked Jan 3 at 16:17
HarshiJHarshiJ
185
add a comment |
I am a beginner in oracle and following is my function definition and invocation part. I am unable to understand the error that I get when I call the function. Please help me rectify my code.
ORA-06550: line 4, column 56: PLS-00103: Encountered the symbol ")" when expecting one of the following: (
create or replace function totalcustomers
RETURN number
IS
total number:=0;
BEGIN
select count(*) into total from customers;
RETURN total;
END;
/
declare sum number;
BEGIN
sum := totalcustomers();
dbms_output.put_line('Total number of customers '||sum);
END;
/
oracle plsql oracle12c
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
asked Jan 3 at 16:17
HarshiJHarshiJ
185
add a comment |
I am a beginner in oracle and following is my function definition and invocation part. I am unable to understand the error that I get when I call the function. Please help me rectify my code.
ORA-06550: line 4, column 56: PLS-00103: Encountered the symbol ")" when expecting one of the following: (
create or replace function totalcustomers
RETURN number
IS
total number:=0;
BEGIN
select count(*) into total from customers;
RETURN total;
END;
/
declare sum number;
BEGIN
sum := totalcustomers();
dbms_output.put_line('Total number of customers '||sum);
END;
/
oracle plsql oracle12c
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
asked Jan 3 at 16:17
HarshiJHarshiJ
185
I am a beginner in oracle and following is my function definition and invocation part. I am unable to understand the error that I get when I call the function. Please help me rectify my code.
ORA-06550: line 4, column 56: PLS-00103: Encountered the symbol ")" when expecting one of the following: (
create or replace function totalcustomers
RETURN number
IS
total number:=0;
BEGIN
select count(*) into total from customers;
RETURN total;
END;
/
declare sum number;
BEGIN
sum := totalcustomers();
dbms_output.put_line('Total number of customers '||sum);
END;
/
oracle plsql oracle12c
oracle plsql oracle12c
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
asked Jan 3 at 16:17
HarshiJHarshiJ
185
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
asked Jan 3 at 16:17
HarshiJHarshiJ
185
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
edited Jan 3 at 16:29
Barbaros Özhan
15.1k71634
15.1k71634
asked Jan 3 at 16:17
HarshiJHarshiJ
185
asked Jan 3 at 16:17
HarshiJHarshiJ
185
asked Jan 3 at 16:17
HarshiJHarshiJ
185
185
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Do not use sum as a variable which is a reserved keyword in Oracle.
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
Yes, correct. Thank you for your help!
– HarshiJ
Jan 5 at 6:05
@HarshiJ you're welcome.
– Barbaros Özhan
Jan 5 at 7:40
add a comment |
Sum is a function, so it's expecting the open paren. Rename the variable.
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
Yes, correct. Thank you for your help!
– HarshiJ
Jan 3 at 16:32
add a comment |
The function invocation part was throwing the mentioned error, because "sum" might be a pre-defined keyword in oracle. Changing the variable as follows helped.
declare x number;
BEGIN
x:=totalcustomers();
dbms_output.put_line(' Total number of customers: '||x);
END;
/
Output :
Statement processed.
Total number of customers: 6
answered Jan 3 at 16:30
HarshiJHarshiJ
185
add a comment |
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
});
}
});
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%2f54026055%2fpls-00103-encountered-the-symbol-when-expecting-one-of-the-following%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Do not use sum as a variable which is a reserved keyword in Oracle.
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
Yes, correct. Thank you for your help!
– HarshiJ
Jan 5 at 6:05
@HarshiJ you're welcome.
– Barbaros Özhan
Jan 5 at 7:40
add a comment |
Do not use sum as a variable which is a reserved keyword in Oracle.
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
Yes, correct. Thank you for your help!
– HarshiJ
Jan 5 at 6:05
@HarshiJ you're welcome.
– Barbaros Özhan
Jan 5 at 7:40
add a comment |
Do not use sum as a variable which is a reserved keyword in Oracle.
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
Do not use sum as a variable which is a reserved keyword in Oracle.
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
answered Jan 3 at 16:28
Barbaros ÖzhanBarbaros Özhan
15.1k71634
15.1k71634
Yes, correct. Thank you for your help!
– HarshiJ
Jan 5 at 6:05
@HarshiJ you're welcome.
– Barbaros Özhan
Jan 5 at 7:40
add a comment |
Yes, correct. Thank you for your help!
– HarshiJ
Jan 5 at 6:05
@HarshiJ you're welcome.
– Barbaros Özhan
Jan 5 at 7:40
Yes, correct. Thank you for your help!
– HarshiJ
Jan 5 at 6:05
Yes, correct. Thank you for your help!
– HarshiJ
Jan 5 at 6:05
@HarshiJ you're welcome.
– Barbaros Özhan
Jan 5 at 7:40
@HarshiJ you're welcome.
– Barbaros Özhan
Jan 5 at 7:40
add a comment |
Sum is a function, so it's expecting the open paren. Rename the variable.
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
Yes, correct. Thank you for your help!
– HarshiJ
Jan 3 at 16:32
add a comment |
Sum is a function, so it's expecting the open paren. Rename the variable.
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
Yes, correct. Thank you for your help!
– HarshiJ
Jan 3 at 16:32
add a comment |
Sum is a function, so it's expecting the open paren. Rename the variable.
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
Sum is a function, so it's expecting the open paren. Rename the variable.
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
answered Jan 3 at 16:29
Gary_WGary_W
7,08311129
7,08311129
Yes, correct. Thank you for your help!
– HarshiJ
Jan 3 at 16:32
add a comment |
Yes, correct. Thank you for your help!
– HarshiJ
Jan 3 at 16:32
Yes, correct. Thank you for your help!
– HarshiJ
Jan 3 at 16:32
Yes, correct. Thank you for your help!
– HarshiJ
Jan 3 at 16:32
add a comment |
The function invocation part was throwing the mentioned error, because "sum" might be a pre-defined keyword in oracle. Changing the variable as follows helped.
declare x number;
BEGIN
x:=totalcustomers();
dbms_output.put_line(' Total number of customers: '||x);
END;
/
Output :
Statement processed.
Total number of customers: 6
answered Jan 3 at 16:30
HarshiJHarshiJ
185
add a comment |
The function invocation part was throwing the mentioned error, because "sum" might be a pre-defined keyword in oracle. Changing the variable as follows helped.
declare x number;
BEGIN
x:=totalcustomers();
dbms_output.put_line(' Total number of customers: '||x);
END;
/
Output :
Statement processed.
Total number of customers: 6
answered Jan 3 at 16:30
HarshiJHarshiJ
185
add a comment |
The function invocation part was throwing the mentioned error, because "sum" might be a pre-defined keyword in oracle. Changing the variable as follows helped.
declare x number;
BEGIN
x:=totalcustomers();
dbms_output.put_line(' Total number of customers: '||x);
END;
/
Output :
Statement processed.
Total number of customers: 6
answered Jan 3 at 16:30
HarshiJHarshiJ
185
The function invocation part was throwing the mentioned error, because "sum" might be a pre-defined keyword in oracle. Changing the variable as follows helped.
declare x number;
BEGIN
x:=totalcustomers();
dbms_output.put_line(' Total number of customers: '||x);
END;
/
Output :
Statement processed.
Total number of customers: 6
answered Jan 3 at 16:30
HarshiJHarshiJ
185
answered Jan 3 at 16:30
HarshiJHarshiJ
185
answered Jan 3 at 16:30
HarshiJHarshiJ
185
answered Jan 3 at 16:30
HarshiJHarshiJ
185
185
add a comment |
add a comment |
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.
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%2f54026055%2fpls-00103-encountered-the-symbol-when-expecting-one-of-the-following%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
