Problems with Int64 and number in Oracle

  • Thread starter Marius Tennes Krogh
  • Start date
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top