Skip to content

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

@jagdish9

Description

@jagdish9

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions