This content has been marked as final. Show 3 replies
I assume you have checked your sequence's 'Increment By' setting and it is 1?
I have the same problem and I've checked my Increment by parm, it is set to 1.
If I execute the same sql statement in TOAD or SQL*Plus I get the next value (i.e. it works). But through OO4O it increments by 2.
I use 8.1.7 on W2K. Different Oracle version and OS version, so it sounds like an OO4O problem.
Yes, Your Options setting of 0 - ORADYN_DEFAULT may be the problem. I would use...
Sounds like a refetch is calling it twice.