I have some Question.
oracle version is 8.1.7.4.0
characterset KO16KSC5601
odac in direct mode. (ODAC 6.90.0.54- current last version, Delphi2009 )
sample code like this...
create table temp
(
userid varchar2(10),
sdate date,
edate date,
wcnt number(13),
rmk varchar2(100)
)
[insert query]
with toraquery1 do
begin
close;
SQL.Clear;
SQL.Add('insert into temp ( ');
SQL.Add(' userid, sdate,edate,wcnt,rmk )');
SQL.Add(' values ( :userid,:sdate,:edate,:wcnt,:rmk) ');
ParamByName('userid').Asstring := '111';
ParamByName('sdate').Asstring := '2009-09-09';
ParamByName('edate').Asstring := '2009-09-09';
ParamByName('wcnt').AsFloat :=313975;
ParamByName('rmk').AsString := 'remark';
Execsql; ==> ora-01401 :inserted value too large for column
end;
if changed to
with toraquery1 do
begin
ParamByName('userid').Asstring := '111';
ParamByName('sdate').Asstring := '2009-09-09';
ParamByName('edate').Asstring := '2009-09-09';
ParamByName('wcnt').Asstring:='313975';
ParamByName('rmk').AsString := 'remark';
Execsql; ==> It works fine
end;
What Can I do solve this problem?
It's Works fine ODAC 6.90.0.51 Trial Version before upgrade
ODAC 6.90.0.54
About ToraQuery's Parambyname option in Direct Mode
Re: About ToraQuery's Parambyname option in Direct Mode
Dear Plash
Why don't you answer to my question?
Please answer anywhere
Why don't you answer to my question?
Please answer anywhere