seq.nextval in select statement of an Oracle eneterprise.
Posted: 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.
Same query with ODBC increments the sequence by1 and works as expected.
we are unable to find whats causing this.
Please help.