-
Notifications
You must be signed in to change notification settings - Fork 81
Description
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.