Re: invalid datatype error when creating primary key

Check whether u have defined user_cd or emp_cd as just number instead of number(6) or number(x). This causes problem for us once. Chida.

In article <3347CD75.3F30_at_hk.super.net>, infoage_at_hk.super.net says...
>
>Steve Miller wrote:
>>
>> I'm trying to create some named primary keys on some tables in a 7.3.2.2
>> 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
>> *
>> ERROR at line 1:
>> ORA-00902: invalid datatype
>>
>> 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.
>
>Could it be because of the Unix Emulator which put some special
>character
>in the name without being seen by you ?
Received on Wed Apr 09 1997 - 00:00:00 CDT