Error is shown at Oracle SQL script that runs correctly
Answered
Hi!
I have a SQL script in my project that runs perfectly with "play" button on a Oracle 11gR2 datasource. However, inspection marks an error:

Have I got something wrong or misconfigured? I'm using:
IntelliJ IDEA 2021.1.3 (Ultimate Edition)
Build #IU-211.7628.21, built on June 30, 2021
Runtime version: 11.0.11+9-b1341.60 amd64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
Windows 10 10.0
This is the code from above image, if you want to give it a try:
CREATE TABLE REN_LOG (
CODIGO NUMBER(15) CONSTRAINT REN_LOG_CODIGO_NN NOT NULL,
CONCEPTO VARCHAR2(30) CONSTRAINT REN_LOG_CONCEPTO_NN NOT NULL,
COD_CONCEPTO NUMBER(15) CONSTRAINT REN_LOG_COD_CONCEPTO_NN NOT NULL,
LOGIN VARCHAR2(50) CONSTRAINT REN_LOG_LOGIN_NN NOT NULL,
FECHA DATE CONSTRAINT REN_LOG_FECHA_NN NOT NULL,
TIPO_EVENTO VARCHAR2(30) CONSTRAINT REN_LOG_TIPO_EVENTO_NN NOT NULL,
DATOS CLOB,
DATE_CREATED DATE,
LAST_UPDATED DATE,
VERSION NUMBER(19) DEFAULT 0 CONSTRAINT REN_LOG_VERSION_NN NOT NULL
)
LOB (DATOS) STORE AS REN_LOG_DATOS_LOB
(TABLESPACE REENER_LOB INDEX REN_LOG_LOB_I);
Please sign in to leave a comment.
looks like bug. I've created bug report on our tracker, please follow and vote
also, there is no error highlighted if no parenthesis, please try.
Txs Yuriy! I get an error when no parentheses before tablespace keyword. INDEX keyword is highlighted, the problem description is:
'(', <flashback archive clause>, AS, BASICFILE, CACHE, CLUSTER, CLUSTERING, COLUMN, COMPRESS, DISABLE, ENABLE, FILESYSTEM_LIKE_LOGGING, ILM, INDEXING, INITRANS, INMEMORY, LOB, LOGGING, MAXTRANS, MONITORING, NESTED, NO, NOCACHE, NOCOMPRESS, NOLOGGING, NOMONITORING, NOPARALLEL, NOROWDEPENDENCIES, ORGANIZATION, PARALLEL, PARTITION, PCTFREE, PCTUSED, RESULT_CACHE, ROW, ROWDEPENDENCIES, SECUREFILE, SEGMENT, STORAGE, TABLESPACE, VARRAY or XMLTYPE expected, got 'INDEX'ah, ok, I see.