Receiving error right parenthesis missing error which executing an PL/SQL block
0
While writing a PL/SQL block I get the error shown below. Kindly let me know the cause of this error?
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
INSERT
INTO CUSTOM_ODILOAD_TABLE_COUNT
(
TABLE_NAME,
ROW_COUNT
)
VALUES
(
TABLENAME(i),
(SELECT COUNT(*) FROM TABLENAME(i)
)
);
END LOOP;
END;
Error:
ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis
ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 -
"line %s, column %s:n%s"
*Cause: Usually a PL/SQL compilation error.
*Action: anonymous block completed
oracle plsql
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
add a comment |
0
While writing a PL/SQL block I get the error shown below. Kindly let me know the cause of this error?
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
INSERT
INTO CUSTOM_ODILOAD_TABLE_COUNT
(
TABLE_NAME,
ROW_COUNT
)
VALUES
(
TABLENAME(i),
(SELECT COUNT(*) FROM TABLENAME(i)
)
);
END LOOP;
END;
Error:
ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis
ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 -
"line %s, column %s:n%s"
*Cause: Usually a PL/SQL compilation error.
*Action: anonymous block completed
oracle plsql
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
Error cause: dynamic table name is not allowed in SQL.
– Lukasz Szozda
Jan 2 at 18:13
Below is the error received: Error report: ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 - "line %s, column %s:n%s" *Cause: Usually a PL/SQL compilation error. *Action: anonymous block completed
– Shanmukha Reddy
Jan 2 at 18:17
add a comment |
0
0
0
While writing a PL/SQL block I get the error shown below. Kindly let me know the cause of this error?
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
INSERT
INTO CUSTOM_ODILOAD_TABLE_COUNT
(
TABLE_NAME,
ROW_COUNT
)
VALUES
(
TABLENAME(i),
(SELECT COUNT(*) FROM TABLENAME(i)
)
);
END LOOP;
END;
Error:
ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis
ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 -
"line %s, column %s:n%s"
*Cause: Usually a PL/SQL compilation error.
*Action: anonymous block completed
oracle plsql
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
While writing a PL/SQL block I get the error shown below. Kindly let me know the cause of this error?
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
INSERT
INTO CUSTOM_ODILOAD_TABLE_COUNT
(
TABLE_NAME,
ROW_COUNT
)
VALUES
(
TABLENAME(i),
(SELECT COUNT(*) FROM TABLENAME(i)
)
);
END LOOP;
END;
Error:
ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis
ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 -
"line %s, column %s:n%s"
*Cause: Usually a PL/SQL compilation error.
*Action: anonymous block completed
oracle plsql
oracle plsql
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
edited Jan 2 at 19:52
a_horse_with_no_name
303k46465561
303k46465561
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
asked Jan 2 at 18:07
Shanmukha ReddyShanmukha Reddy
296
296
Error cause: dynamic table name is not allowed in SQL.
– Lukasz Szozda
Jan 2 at 18:13
Below is the error received: Error report: ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 - "line %s, column %s:n%s" *Cause: Usually a PL/SQL compilation error. *Action: anonymous block completed
– Shanmukha Reddy
Jan 2 at 18:17
add a comment |
Error cause: dynamic table name is not allowed in SQL.
– Lukasz Szozda
Jan 2 at 18:13
Below is the error received: Error report: ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 - "line %s, column %s:n%s" *Cause: Usually a PL/SQL compilation error. *Action: anonymous block completed
– Shanmukha Reddy
Jan 2 at 18:17
Error cause: dynamic table name is not allowed in SQL.
– Lukasz Szozda
Jan 2 at 18:13
Error cause: dynamic table name is not allowed in SQL.
– Lukasz Szozda
Jan 2 at 18:13
Below is the error received: Error report: ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 - "line %s, column %s:n%s" *Cause: Usually a PL/SQL compilation error. *Action: anonymous block completed
– Shanmukha Reddy
Jan 2 at 18:17
Below is the error received: Error report: ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 - "line %s, column %s:n%s" *Cause: Usually a PL/SQL compilation error. *Action: anonymous block completed
– Shanmukha Reddy
Jan 2 at 18:17
add a comment |
1 Answer
1
active
oldest
votes
2
You cannot have dynamic table name for static query(i.e. table name cannot be parametrized):
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
cnt INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || TABLENAME(i) INTO cnt;
INSERT INTO CUSTOM_ODILOAD_TABLE_COUNT (TABLE_NAME, ROW_COUNT)
VALUES ( TABLENAME(i), cnt);
END LOOP;
END;
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
Thanks, will check and update
– Shanmukha Reddy
Jan 2 at 18:18
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
});
}
});
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%2f54011123%2freceiving-error-right-parenthesis-missing-error-which-executing-an-pl-sql-block%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
2
You cannot have dynamic table name for static query(i.e. table name cannot be parametrized):
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
cnt INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || TABLENAME(i) INTO cnt;
INSERT INTO CUSTOM_ODILOAD_TABLE_COUNT (TABLE_NAME, ROW_COUNT)
VALUES ( TABLENAME(i), cnt);
END LOOP;
END;
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
Thanks, will check and update
– Shanmukha Reddy
Jan 2 at 18:18
add a comment |
2
You cannot have dynamic table name for static query(i.e. table name cannot be parametrized):
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
cnt INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || TABLENAME(i) INTO cnt;
INSERT INTO CUSTOM_ODILOAD_TABLE_COUNT (TABLE_NAME, ROW_COUNT)
VALUES ( TABLENAME(i), cnt);
END LOOP;
END;
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
Thanks, will check and update
– Shanmukha Reddy
Jan 2 at 18:18
add a comment |
2
2
2
You cannot have dynamic table name for static query(i.e. table name cannot be parametrized):
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
cnt INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || TABLENAME(i) INTO cnt;
INSERT INTO CUSTOM_ODILOAD_TABLE_COUNT (TABLE_NAME, ROW_COUNT)
VALUES ( TABLENAME(i), cnt);
END LOOP;
END;
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
You cannot have dynamic table name for static query(i.e. table name cannot be parametrized):
DECLARE
TYPE TABLE_NAME IS VARRAY(17) OF VARCHAR(255);
TABLENAME TABLE_NAME;
TOTAL INTEGER;
cnt INTEGER;
BEGIN
TABLENAME := TABLE_NAME ('FA_AS_ASSIGNMENTS','FA_PE_PHONES' );
TOTAL := TABLENAME.COUNT;
FOR i IN 1 .. TOTAL
LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || TABLENAME(i) INTO cnt;
INSERT INTO CUSTOM_ODILOAD_TABLE_COUNT (TABLE_NAME, ROW_COUNT)
VALUES ( TABLENAME(i), cnt);
END LOOP;
END;
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
edited Jan 2 at 18:19
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
answered Jan 2 at 18:17
Lukasz SzozdaLukasz Szozda
81.8k1069109
81.8k1069109
Thanks, will check and update
– Shanmukha Reddy
Jan 2 at 18:18
add a comment |
Thanks, will check and update
– Shanmukha Reddy
Jan 2 at 18:18
Thanks, will check and update
– Shanmukha Reddy
Jan 2 at 18:18
Thanks, will check and update
– Shanmukha Reddy
Jan 2 at 18:18
add a comment |
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%2f54011123%2freceiving-error-right-parenthesis-missing-error-which-executing-an-pl-sql-block%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
Error cause: dynamic table name is not allowed in SQL.
– Lukasz Szozda
Jan 2 at 18:13
Below is the error received: Error report: ORA-06550: line 19, column 40: PL/SQL: ORA-00907: missing right parenthesis ORA-06550: line 10, column 5: PL/SQL: SQL Statement ignored 06550. 00000 - "line %s, column %s:n%s" *Cause: Usually a PL/SQL compilation error. *Action: anonymous block completed
– Shanmukha Reddy
Jan 2 at 18:17