Querying a long value

When querying two tables with a long value in each, I continually get ORA-01002: fetch out of sequence

I've tried setting the long value to a large number, but I cannot seem to get past the problem.

The two tables have a 1-1 relationship. I can't seem to find any information

on the subject, so while I continue looking, if anyone has any information that would be great.

Here's an example of what I'm doing.

select a.longvalue1, b.longvalue2 from table1 a, table2 b where a.id = b.id;

Evan S.

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net