CODEWITHSUNDEEP
oracle-database
Lokomotywa
Lokomotywa

Reputation: 2844

create table with clob column fails

What is the Problem with

 CREATE TABLE sessions (session_data CLOB(4000),SESSION_ID VARCHAR2(40));

I always get a Query failed #907 ORA-00907: Rechte Klammer fehlt

Upvotes: 1

Views: 13839

Answers (1)

user3278460
user3278460

Reputation:

don't specify clob size

CREATE TABLE sessions (session_data CLOB,SESSION_ID VARCHAR2(40));

Upvotes: 5

Related Questions