zpa icon indicating copy to clipboard operation
zpa copied to clipboard

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

Open jagdish9 opened this issue 3 years ago • 0 comments

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.

jagdish9 avatar Apr 23 '21 05:04 jagdish9