on 03-17-2009 5:54 AM
我在Dictionary工程里面创建了一个数据库表(数据库为ORACLE),我想设置一个字段的属性为Long(BigInt)但是我用TOAD查看的时候该字段类型为NUMBER(10),而同一张表的另一个字段同样设置为Long(BigInt)在TOAD中的类型就是NUMBER(19),我想在该字段NUMBER(10)中存储一个长整形的数字,系统报错ORA-01438: value larger than specified precision allowed for this column,在另一个字段NUMBER(19)中存储则没有问题。为什么会出现这样的情况,我要怎么才能将该字段的精度设置成19?
直接再ddIc里面把number(10)改成NUMBER(19)行不行?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
问题解决了,我把数据类型改成String 32 发布,然后再改回来就OK了,晕倒。不过还是谢谢你,让我知道了有DDIC这个东西。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.