unidac报ora-12899

[laowu1215]

使用unidac 3.00.0.6 版本，连接数据库Oracle Database 11g Enterprise Edition 11.1.0.6.0 ，使用中文字符集：ZHS16GBK，进行SQL insert操作，提示ora-12899,具体如下：
oq2.Close ;
oq2.SQL.Text :='insert into T_CollectJobState (Lsh,Collrq,CollTime,CollectBox,RealRecNum,CollRecNum,headNum,roadNum,unsucNum,NonRec,TestNum,State,jsjh,czyh,pt)';
oq2.SQL.Add('Values(:lsh,:collrq,:colltime,:CollectBOx,:RealRecNum,0,0,0,0,0,0,0,:jsjh,:czyh,1)');
oq2.ParamByName('lsh').AsString :='123456';
oq2.ParamByName('collrq').AsString :='20100301';
oq2.ParamByName('colltime').AsString :='120000';
oq2.ParamByName('CollectBox').AsString :='00001000';
oq2.ParamByName('RealRecNum').Asinteger :=1000;
oq2.ParamByName('jsjh').AsString :='99' ;
oq2.ParamByName('czyh').AsString :='001' ;
oq2.Prepared:=true;
oq2.ExecSQL ;
ORA-12899: value too large for column “T_COLLECTJOBSTATE"."COLLTIME" (actual: 8, maximum: 6)
注：colltime数据库中定义varchar2(6)
请各位大虾帮忙看看，谢谢

[laowu1215]

注：使用的delphi2010

[亮剑_]

字段超长，长度为6，实际为8
'120000'里不会有全角字符吧

[laowu1215]

不是全角，我怀疑是unidac问题，因为我使用UniConnection，直接连接数据库，就报这个错误;
不直接连接oracle，通过oracle的服务连接名连接，没有问题

[火龙岛主]

字符集不匹配，注意2010中的string类型均为widestring类型。

[starluck]

应该是字符宽度的问题，

params的size 是多少？

[laowu1215]

dbmonitor监控结果：
2010/3/4 17:50:14 0.016 SQL Unprepare: insert into T_CollectJobState (Lsh,Collrq,CollTime,CollectBox,RealRecNum,CollRecNum,headNum,roadNum,unsucNum,NonRec,TestNum,State,jsjh,czyh,pt)
:lsh(WideString[6])='123456'
:collrq(WideString[8])='20100301'
:colltime(WideString[6])='120000'
:CollectBOx(WideString[8])='00001000'
:RealRecNum(Integer)=1000
:jsjh(WideString[2])='99'
:czyh(WideString[3])='001' Complete
2010/3/4 17:50:14 0.000 Disconnect: ***@***.***.***.***:1521:***** Complete
2010/3/4 17:50:14 0.171 Connect: ***@***.***.***.***:1521:***** Complete
2010/3/4 17:50:14 0.000 SQL Prepare: insert into T_CollectJobState (Lsh,Collrq,CollTime,CollectBox,RealRecNum,CollRecNum,headNum,roadNum,unsucNum,NonRec,TestNum,State,jsjh,czyh,pt)
Values(:lsh,:collrq,:colltime,:CollectBOx,:RealRecNum,0,0,0,0,0,0,0,:jsjh,:czyh,1)
:lsh(WideString[6])='123456'
:collrq(WideString[8])='20100301'
:colltime(WideString[6])='120000'
:CollectBOx(WideString[8])='00001000'
:RealRecNum(Integer)=1000
:jsjh(WideString[2])='99'
:czyh(WideString[3])='001' Complete
2010/3/4 17:50:14 1.014 SQL Execute: insert into T_CollectJobState (Lsh,Collrq,CollTime,CollectBox,RealRecNum,CollRecNum,headNum,roadNum,unsucNum,NonRec,TestNum,State,jsjh,czyh,pt)
Values(:lsh,:collrq,:colltime,:CollectBOx,:RealRecNum,0,0,0,0,0,0,0,:jsjh,:czyh,1)
:lsh(WideString[6])='123456'
:collrq(WideString[8])='20100301'
:colltime(WideString[6])='120000'
:CollectBOx(WideString[8])='00001000'
:RealRecNum(Integer)=1000
:jsjh(WideString[2])='99'
:czyh(WideString[3])='001'

[laowu1215]

New build of UniDAC version 3.00.0.7 is available for download now.
This version includes:
Ability to use Access system database added

Added DetectFieldsOnPrepare parameter for NexusDB ODBC driver

Added ability to send call stack information to the dbMonitor component

Fixed bug with refreshing record when using master/detail relationship

Fixed bug with LocalUpdate in the CachedUpdates mode

Fixed bug with displaying nvarchar2 fields when UseUnicode is true

Fixed bug with getting IndexFieldNames list in design time

Fixed several bugs with getting information about SQLite database using the TUniMetadata component

Fixed bug with processing TableInfo for SQLite

Fixed bug with DBMonitor for C++ Builder 6

这应是BUG，正在期待新的版本下载。。。。。。

[laowu1215]

测试UniDAC version 3.00.0.7 ，错误依旧
params的size如下图：

[byteh]

如果确定是长度问题，数据库可修改的话就修改表结构吧！

没必要管他是谁的bug

[laowu1215]

没用的，改了结构又报其他错误

[Alessandro_]

[Quote=引用 9 楼 byteh 的回复:]
如果确定是长度问题，数据库可修改的话就修改表结构吧！

没必要管他是谁的bug
[/Quote]

我在我们那系统也出现这种问题，说超过了最大值，实际值为101，最大值为100

但是我把它最大值修改成120，结果还是报错了，跟踪出来实际值为121，最大值为120.

[Henry.6]

升级到3.5看看