This content has been marked as final. Show 2 replies
I'm not sure what's causing your problem, but I did want to ensure that you're aware that there's no way to guarantee a gap-free Oracle sequence. The only way to do this is through a hideous hack where you create a table, rather than a sequence, with one row in it, though this forces all your session to serialize.
One of many askTom links on the subject...
I've run into a similar problem under Windows 2000. The solution I found is to change the "Set OraDynaset..." statement to the following:
"Set OraDynaset = oraDatabase.DBCreateDynaset(sqlString, 20&)"
The option '20&' at the end will cancel out the automatic refetch which is done by the Oracle Database object.