奇怪的ORA-01455: 转换列溢出整数数据类型 报错
查看( 217 ) /
评论( 8 )
TAG:
-
cunny发布于2006-11-07 12:16:06
-
RESOURSE_SUM INTEGER,
INTEGER是Oracle的数据类型吗?把它改成Number (10)看看
INTEGER
This ANSI datatype will be accepted by Oracle - it is actually a synonym for NUMBER(38)
-
naf_naf发布于2006-11-07 13:37:23
-
我在10g上测试没有问题

-
seron
发布于2006-11-07 16:28:35
-
我把它改成NUMBER也不行啊,其他都没问题
-
seron
发布于2006-11-07 18:01:41
-
alter table USER_CATEGORY
add constraint FK_USER_CAT_REFERENCE_USER_CAT foreign key (PARENT_CATEGORY_ID)
references USER_CATEGORY (CATEGORY_ID);
对了,忘记了,我是加上这个外键才出现这种问题的
-
hgeng发布于2006-11-08 03:21:08
-
Are you sure you want to define CATEGORY_ID as NUMBER(8)? If you do so, you can not insert record with a 9-digit value as CATEGORY_ID. Usually the ID is generated from a sequence, and you will have problem sooner or later. Simply define it as NUMBER will work.
-
seron
发布于2006-11-08 10:20:15
-
QUOTE:
最初由 hgeng 发布
感谢,我试定义为NUMBER就可以了,但NUMBER没有长度限制啊,我这个是用户自定义分类,一个网站用户可能会有多个自定义分类,定义为NUMBER会不够用的,难道就没有其它解决办法吗
[B]Are you sure you want to define CATEGORY_ID as NUMBER(8)? If you do so, you can not insert record with a 9-digit value as CATEGORY_ID. Usually the ID is generated from a sequence, and you will have problem sooner or later. Simply define it as NUMBER will work. [/B]
-
horizon
发布于2006-11-08 10:56:15
-
定义大点贝
-
seron
发布于2006-11-08 12:21:10
-
QUOTE:
最初由 horizon 发布
晕倒,定义大点我上面的问题岂不是白说了..就是因为定义了数据长度才出现的
[B]定义大点贝 [/B]
