Page 1 of 1

seq.nextval in select statement of an Oracle eneterprise.

Posted: Wed Jun 02, 2010 12:22 am
by austin_316
We are using oracle seq.nextval in select statement of an Oracle eneterprise. When we run the job its incrementing the sequence by 2.
Same query with ODBC increments the sequence by1 and works as expected.

we are unable to find whats causing this.

Please help.

Re: seq.nextval in select statement of an Oracle eneterprise

Posted: Wed Jun 02, 2010 2:23 am
by g_rkrish
Please post in the respective forum

Posted: Wed Jun 02, 2010 2:23 am
by ArndW
Please post your query, that would assist in any debugging.

Posted: Wed Jun 02, 2010 2:32 am
by austin_316
This is the query we are using:

select test_seq.nextval from dual

Posted: Wed Jun 02, 2010 2:36 am
by ArndW
You probably have a parallel configuration file with 2 nodes.

Posted: Wed Jun 02, 2010 5:47 am
by chulett
I would assume so as well.