Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

When I try to execute the SQL statment below in Oracle SQL Developer:

CREATE TABLE Nrom1Tab ( Sig TEXT NOT NULL PRIMARY KEY, 
   DocSubject TEXT,  
   DocClassification TEXT,  
   DepName VARCHAR, 
   OrgName TEXT,  
   FromInf  TEXT,   
   ToInf TEXT,    
   DateInf TEXT, 
   NoteInf TEXT );

It shows this error:

enter image description here

share|improve this question

4 Answers

up vote 5 down vote accepted

I'm not sure what the error message is, however

  1. TEXT is not a valid data type in Oracle.
  2. VARCHAR is a valid data type but you would need to specify the length (i.e. VARCHAR(10)) would allow up to 10 bytes of storage (assuming a default NLS_LENGTH_SEMANTICS of BYTE). It would generally be preferred to use the VARCHAR2 data type rather than VARCHAR as well.
share|improve this answer
up vote 1 down vote

I believe you have to give VARCHAR an amount like VARCHAR(50).

share|improve this answer
up vote 1 down vote 
CREATE TABLE Nrom1Tab 
( 
    Sig TEXT PRIMARY KEY, DocSubject TEXT,  DocClassification TEXT,  
    DepName VARCHAR(100), -- Missing LENGTH
    OrgName TEXT,  FromInf  TEXT,   ToInf TEXT,   DateInf TEXT, NoteInf TEXT );
share|improve this answer
1  
Still won't work. Text is not a valid Oracle datatype. – a_horse_with_no_name Jan 25 '12 at 19:48
up vote 2 down vote

I believe the error complaining about missing a left parenthesis, is angry that VARCHAR doesn't have a length defined. The error references column 113, which would be where the left parenthesis should be, the 114th character on that line.

Justin also correctly points out TEXT is not a valid datatype. While I don't think that is causing the error you're seeing, it'll be an error very soon :)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.