error in sequence.
Hello everyone.
I said something happening to me since migrating from 9i to 10g.
I have an application that generates dboids using select:
"SELECT FROM DUAL PERSEQ.NEXTVAL"
being "perseq" sequence.
This value perseq.nextval is introduced into a visual basic function and generates a dboid. This visual function is in the "client"
What is happening to us is that if we launched a process to do about 1000 insert into a table gives only duplicate key error:
"[Oracle] [ODBC] [Ora] ORA-00001: unique constraint"
But this error does not always happen, but sometimes before and sometimes comes out later, or not even
I said something happening to me since migrating from 9i to 10g.
I have an application that generates dboids using select:
"SELECT FROM DUAL PERSEQ.NEXTVAL"
being "perseq" sequence.
This value perseq.nextval is introduced into a visual basic function and generates a dboid. This visual function is in the "client"
What is happening to us is that if we launched a process to do about 1000 insert into a table gives only duplicate key error:
"[Oracle] [ODBC] [Ora] ORA-00001: unique constraint"
But this error does not always happen, but sometimes before and sometimes comes out later, or not even
0