seq.nextval in select statement of an Oracle eneterprise.

austin_316 · Post by **austin_316** » Wed Jun 02, 2010 12:22 am

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.

g_rkrish · Post by **g_rkrish** » Wed Jun 02, 2010 2:23 am

Please post in the respective forum

ArndW · Post by **ArndW** » Wed Jun 02, 2010 2:23 am

Please post your query, that would assist in any debugging.

austin_316 · Post by **austin_316** » Wed Jun 02, 2010 2:32 am

This is the query we are using:

select test_seq.nextval from dual

ArndW · Post by **ArndW** » Wed Jun 02, 2010 2:36 am

You probably have a parallel configuration file with 2 nodes.

chulett · Post by **chulett** » Wed Jun 02, 2010 5:47 am

I would assume so as well.

DSXchange

seq.nextval in select statement of an Oracle eneterprise.

seq.nextval in select statement of an Oracle eneterprise.

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