Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Getting unable to parse error when used ENABLE keyword in Create Table statement #149

Open
jagdish9 opened this issue Apr 23, 2021 · 0 comments

Comments

@jagdish9
Copy link

Hi,

I used ENABLE keyword in CREATE TABLE statement as below

CREATE TABLE TPA_MASTER
(
CONFIGID VARCHAR2(100 BYTE) PRIMARY KEY ENABLE,
NO_OF_PWD_ATTEMPTS NUMBER,
SESSION_TIME_DURATION NUMBER NOT NULL ENABLE,
PWD_EXPIRY_PERIOD NUMBER,
SUSPECT_COUNT NUMBER NOT NULL ENABLE,
SUSPECT_FREQUENCY NUMBER NOT NULL ENABLE,
NO_RULE_FREQUENCY NUMBER NOT NULL ENABLE
)

But getting below Parse Error.

org.sonar.plugins.plsqlopen.api.sslr.RecognitionException: Parse error at line 17 column 50:

11: first_name VARCHAR2(42) NOT NULL,
12: last_name VARCHAR2(42) NOT NULL
13: );
14:
15: CREATE TABLE TPA_MASTER
16: (
--> CONFIGID VARCHAR2(100 BYTE) PRIMARY KEY ENABLE,
18: NO_OF_PWD_ATTEMPTS NUMBER,
19: SESSION_TIME_DURATION NUMBER NOT NULL ENABLE,
20: PWD_EXPIRY_PERIOD NUMBER,
21: SUSPECT_COUNT NUMBER NOT NULL ENABLE,
22: SUSPECT_FREQUENCY NUMBER NOT NULL ENABLE,
23: NO_RULE_FREQUENCY NUMBER NOT NULL ENABLE

when i removed ENABLE keyword, it works fine.

Can you please review and provide your feedback.

Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant