Search found 3 matches

by yossarian
17.06.2009, 11:00
Forum: 6.6 - stable
Topic: Oracle ora-01455 converting column overflows integer dataty
Replies: 4
Views: 758

Thanks Mark!

There is a solution, but not too perfect for me. I have to convert this fields to character type with to_char() function.

Yossarian
by yossarian
17.06.2009, 09:33
Forum: 6.6 - stable
Topic: Oracle ora-01455 converting column overflows integer dataty
Replies: 4
Views: 758

I tested this situation with another database component named anydac and that handled this situation correctly. I created a table on an MS SQL server with bigint fields and i filled it with numbers greater than integer range limit and Zeos handle it correctly. So the problem must be in the Zeos orac...
by yossarian
16.06.2009, 11:11
Forum: 6.6 - stable
Topic: Oracle ora-01455 converting column overflows integer dataty
Replies: 4
Views: 758

Oracle ora-01455 converting column overflows integer dataty

Hi! I use ZEOS 6.6.3 and Oracle 10g. We have big integer fields in some table. defined as NUMBER(15). When values in this fields are greater than maximum value of integer type I get this oracle error. I suspect Zeos use integer type for this fields instead of int64. I tried to check it in zeos sourc...