invalid datatype error when creating primary key

[Quoted] [Quoted] I'm trying to create some named primary keys on some tables in a 7.3.2.2 [Quoted] database and I'm getting the following error:

comex> alter table service.gp_cd2emp add constraint pk_gp_cd2emp1_c01   2 primary key (user_cd, emp_cd);
alter table service.gp_cd2emp add constraint pk_gp_cd2emp1_c01

                                             *

I've tried adding quotes, parentheses, etc. and it just DOESN'T want to work. I can add an unnamed constraint just fine:

comex> alter table service.gp_cd2emp add primary key (user_cd, emp_cd);

Table altered.

Anyone seen this before - Oracle support is working on the problem, but I really need to push this project forward.

Any input appreciated!!

Steve Received on Wed Apr 02 1997 - 00:00:00 CEST