invalid indentifier errors in sql script...plz help

Dev Shed Forums Sponsor:

February 11th, 2005, 03:29 PM

mikestan21

Registered User

Join Date: Aug 2003

Posts: 21

Time spent in forums: 1 h 52 m 7 sec
Reputation Power: 0

invalid indentifier errors in sql script...plz help

I've got this create table script below, but it keeps giving errors 904 and I can't figure out why? I tried changing the field and date columns to other names since I thought they were reserve words, but that doesn't work either?
Any help is appreciated,
stan

date date,
*
ERROR at line 7:
ORA-00904: : invalid identifier

Code:

drop table image;
drop table image_be_number;
drop table image_jpg;
drop table image_request;
drop table user;
drop table role;
drop table source;
drop table department;


create table image
(
image_id		int NOT NULL,
name			varchar2(50),
path			varchar2(100),
country			varchar2(50),
file			varchar2(50),
date			date,
location		varchar2(50),
link			varchar2(100),
status			varchar2(50),
source			varchar2(50),
priority		varchar2(50),
request_type		varchar2(50),
received_date		date,
processed_date		date,
expiration_date		date,
posted			varchar2(50),
PRIMARY KEY(image_id)
);


create table image_be_number
(
be_number		int NOT NULL,
image_id		int NOT NULL,
REFERENCES image(image_id),
PRIMARY KEY(be_number)
);


create table image_jpg
(
jpg_id			int NOT NULL,
name			varchar2(50),
path			varchar2(100),
image_id		int NOT NULL,
be_number		int NOT NULL,
REFERENCES image(image_id)
image_be_number(be_number),
PRIMARY KEY(jpg_id)
);


create table image_request
(
request_id		int,
image_id		int NOT NULL,
department_id		int NOT NULL,
user_id			int NOT NULL,
date			date,
REFERENCES image(image_id)
department(department_id)
user(user_id),
);


create table user
(
user_id			int NOT NULL,
password		varchar2(10),
role_id			int NOT NULL,
first_name		varchar2(50),
last_name		varchar2(50),
email			varchar2(50),
--REFERENCES role(role_id),
PRIMARY KEY(user_id)
);


create table role
(
role_id			int NOT NULL,
PRIMARY KEY(role_id)
);


create table source
(
source_id		int NOT NULL,
name			varchar2(50),
address			varchar2(50),
email			varchar2(50),
PRIMARY KEY(source_id)
);


create table department
(
department_id		int NOT NULL,
department		varchar2(50),
PRIMARY KEY(department_id)
);

February 11th, 2005, 03:37 PM

jim mcnamara

......@.........

Join Date: Jun 2004

Posts: 1,308

Time spent in forums: 1 Week 3 Days 5 h 20 m 49 sec
Reputation Power: 48

The name of a field ( column) cannot be a datatype - date, number, varchar, varchar2, etc. You have a field named 'DATE'

February 11th, 2005, 03:42 PM

mikestan21

Registered User

Join Date: Aug 2003

Posts: 21

Time spent in forums: 1 h 52 m 7 sec
Reputation Power: 0

Quote:

Originally Posted by jim mcnamara

The name of a field ( column) cannot be a datatype - date, number, varchar, varchar2, etc. You have a field named 'DATE'

I realize that, and like I said, I've already changed it but am still getting the same error?

Anything else that you can see might be causing this?

Code:

drop table image;
drop table image_be_number;
drop table image_jpg;
drop table image_request;
drop table user;
drop table role;
drop table source;
drop table department;


create table image
(
image_id		int NOT NULL,
name			varchar2(50),
path			varchar2(100),
country			varchar2(50),
file			varchar2(50),
create_date		date,
location		varchar2(50),
link			varchar2(100),
status			varchar2(50),
source			varchar2(50),
priority		varchar2(50),
request_type		varchar2(50),
received_date		date,
processed_date		date,
expiration_date		date,
posted			varchar2(50),
PRIMARY KEY(image_id)
);


create table image_be_number
(
be_number		int NOT NULL,
image_id		int NOT NULL,
REFERENCES image(image_id),
PRIMARY KEY(be_number)
);


create table image_jpg
(
jpg_id			int NOT NULL,
name			varchar2(50),
path			varchar2(100),
image_id		int NOT NULL,
be_number		int NOT NULL,
REFERENCES image(image_id)
image_be_number(be_number),
PRIMARY KEY(jpg_id)
);


create table image_request
(
request_id		int,
image_id		int NOT NULL,
department_id		int NOT NULL,
user_id			int NOT NULL,
date			date,
REFERENCES image(image_id)
department(department_id)
user(user_id),
);


create table user
(
user_id			int NOT NULL,
password		varchar2(10),
role_id			int NOT NULL,
first_name		varchar2(50),
last_name		varchar2(50),
email			varchar2(50),
--REFERENCES role(role_id),
PRIMARY KEY(user_id)
);


create table role
(
role_id			int NOT NULL,
PRIMARY KEY(role_id)
);


create table source
(
source_id		int NOT NULL,
name			varchar2(50),
address			varchar2(50),
email			varchar2(50),
PRIMARY KEY(source_id)
);


create table department
(
department_id		int NOT NULL,
department		varchar2(50),
PRIMARY KEY(department_id)
);

February 11th, 2005, 03:50 PM

jim mcnamara

......@.........

Join Date: Jun 2004

Posts: 1,308

Time spent in forums: 1 Week 3 Days 5 h 20 m 49 sec
Reputation Power: 48

there is no such thing as 'int'....

Use NUMBER(15) or whatever size you need.

February 12th, 2005, 03:53 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Munich, Bavaria

Posts: 1,007

Time spent in forums: 1 Week 3 Days 13 h 56 m 17 sec
Reputation Power: 67

Quote:

Originally Posted by jim mcnamara

there is no such thing as 'int'....

Actually there is INTEGER, and I prefer to use that instead of NUMBER(22) because - in my opinion - it's much clearer.

Thomas

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: