ddl error? help! please

ALTER TABLE transaction ADD(CONSTRAINT ck_status CHECK((transaction_status = 'Open') OR (transaction_status = 'Closed'));

ORA-00907: missing right parenthesis

and:

ALTER TABLE transaction ADD(CONSTRAINT fk_trans2 FOREIGN KEY(item_id) references item(item_id))

*
ERROR at line 1:
ORA-02270: no matching unique or primary key for this column-list

pk definition for item is:

ALTER TABLE item ADD(CONSTRAINT cpk_ip_iid_sn_im PRIMARY KEY(item_prefix,item_id,item_sequence,item_media)); Received on Sun Feb 11 2001 - 09:44:23 CST