TOracleConnection and SQLQuery1 ,got error ORA-01455 converting column overflows integer datatype
Original Reporter info from Mantis: kevin.jiang
-
Reporter name: kevin jiang
Original Reporter info from Mantis: kevin.jiang
- Reporter name: kevin jiang
Description:
TOracleConnection and SQLQuery1 ,got error ORA-01455 converting column overflows integer datatype
create table T_TEST
(
A1 NUMBER(6),
A2 NUMBER(8),
A3 NUMBER(9),
A4 NUMBER(10),
A5 NUMBER(11),
A6 NUMBER(15),
A7 NUMBER(18),
A8 NUMBER(15,2)
);
--then insert one row
insert into T_TEST (A1, A2, A3, A4, A5, A6, A7, A8)
values (123456, 12345678, 123456789, 1234567890, 12345678901, 123456789012345, 123456789012346000, 1111111.11);
commit;
var
SQLQuery1: TSQLQuery;
SqlQuery1.Close;
SqlQuery1.SQL.Clear;
sqlQuery1.SQL.Add('select A1,A2,A3,A4 from t_test') ;
SqlQuery1.Open;
these flds bellow number(11) no problem.
but when you query A5 got that error ORA-01455.
SqlQuery1.Close;
SqlQuery1.SQL.Clear;
sqlQuery1.SQL.Add('select A5 from t_test') ;
SqlQuery1.Open;
and did not support NUMBER(15,2) ,if you select A8 then return nil.
Mantis conversion info:
- Mantis ID: 19340
- OS: windows
- OS Build: 7
- Platform: W32
- Version: 0.9.30