Problems with Int64 and number in Oracle

microsoft.public.dotnet.framework.adonet

2 May 2006 12:44 PM

Marius Tennes Krogh

Hi

I have a table in oracle like this:
RecID:             NUMBER
Description:     VARCHAR2(256)

If I try to get a record which has a "big" int64 value it won't return any
record.

I can insert a record like this:
insert into MyTable (RecID, Description) values (2821747746824216, 'Test
record')

I can list all rows in table with the sql "select * from MyTable". It then
shows:
RecID                                    Description
2,82174774682421E+15    Test record

But if I try to get the record by using the record ID: "select * from
MyTable where RecID=2821747746824216" I don't get any result. I have tried
by using parameters in the sql, but with no luck.
If the Record ID is a "small" int64, like 282174, it works fine.

Any ideas?

Marius