Oracle Data Access Components (ODAC) - Support

by Devart (formerly Core Lab) - Product Type: Component / VCL

Support Forum

Oracle Data Access Components (ODAC) kevin1_hsu [Taiwan ROC] 22-Apr-2011 11:35:55

接上貼內容:

但是修改為如下的模式卻不會有問題.
Insert:
vSql := 'INSERT INTO DR_PALLET' +
' (PALLET, PALLET_TYPE, TQTY, IQTY, CLOSE, UP_PALLET, P_GW, P_NW,' +
' P_L, P_W, P_H, HAWB, INCAR_DATE, PALLET_CODE, CRSTAMP)' +
' VALUES (' + AnsiQuotedStr('QG1=899014000001', #39) + ', ' + AnsiQuotedStr('PACK', #39) +
', 0, 4, ' + AnsiQuotedStr('XX', #39) + ', NULL, 4.2, 0,' + ' 64, 41, 63, ' + AnsiQuotedStr('X', #39) +
', SYSDATE, ' + AnsiQuotedStr('X', #39) + ', SYSDATE)';
Close;
Sql.Clear;
Sql.Add(vSql);
ExecSQL;
Reply

Oracle Data Access Components (ODAC) kevin1_hsu [Taiwan ROC] 22-Apr-2011 11:35:06

Hi,
我公司有從貴司購買ODAC6.9,目前發現測試出連接Oracle 9i Database時對TABLE通過以下方式做UPDATE/INSERT時會出現以下相關錯誤.
該問題為ODAC Bug?請問有解決方法嗎？
並且也有下載ODAC7.10試用版本測試也是同樣問題.
對Oracle 9i Database做Insert和Update會操作有問題.
Insert:
Close;
Sql.Clear;
Sql.Add('INSERT INTO DR_PALLET' +
' (PALLET, PALLET_TYPE, TQTY, IQTY, CLOSE, UP_PALLET, P_GW, P_NW,' +
' P_L, P_W, P_H, HAWB, INCAR_DATE, PALLET_CODE, CRSTAMP)' +
' VALUES (:PALLET, :PALLET_TYPE, :TQTY, :IQTY, :CLOSE, :UP_PALLET, :P_GW, :P_NW,' +
' :P_L, :P_W, :P_H, :HAWB, SYSDATE, :PALLET_CODE, SYSDATE)');
ParamByName('PALLET').AsString := 'QG1=899014000001';
ParamByName('PALLET_TYPE').AsString := 'PALLET';
ParamByName('TQTY').AsInteger := 0;
ParamByName('IQTY').AsInteger := 8;
ParamByName('CLOSE').AsString := 'I';
ParamByName('UP_PALLET').AsString := 'X';
ParamByName('P_GW').AsFloat := 3.2;
ParamByName('P_NW').AsFloat := 2.3;
ParamByName('P_L').AsFloat := 10.1;
ParamByName('P_W').AsFloat := 12;
ParamByName('P_H').AsFloat := 12;
ParamByName('HAWB').AsString := 'XX';
ParamByName('PALLET_CODE').AsString := 'X';
ExecSQL;
Error Message:
ORA-01401: inserted value too large for column
Update:
Close;
Sql.Clear;
Sql.Add('UPDATE DR_PALLET SET HAWB = :HAWB WHERE PALLET = :PALLET');
ParamByName('PALLET').AsString := 'QG1=899014000001';
ParamByName('HAWB').AsString := 'X';
ExecSQL;
Error Message:
ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
Reply