Bad oracle syntax ALTER TABLE tship_xref ADD CONSTRAINT fk_tship_location FOREIGN KEY (locationid) REFERENCES tship_location
--- "S. Isaac Dealey" <[EMAIL PROTECTED]> wrote: > I'm trying to create a foreign key constraint in > Oracle -- I have this sql > script: > > > > create table tship_location ( > locationid varchar(35) primary key, > locationname varchar(25) not null, > locationorder int not null > ) > > create table tship_pricerange ( > priceid varchar(35) primary key, > pricemin float not null > ) > > create table tship_xref ( > locationid varchar(35) not null, > priceid varchar(35) not null, > shippingcost varchar(25) not null > ) > > alter table tship_xref add > constraint (fk_tship_location) foreign key > references tship_location (locationid), > constraint (fk_tship_price) foreign key > references tship_pricerange (priceid) > > > > which produces this error from the Oracle server: > ORA-00902: invalid datatype ===== I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4