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.
seq.nextval in select statement of an Oracle eneterprise.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 80
- Joined: Fri Aug 21, 2009 7:49 am
- Location: India
Please post your query, that would assist in any debugging.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 80
- Joined: Fri Aug 21, 2009 7:49 am
- Location: India
You probably have a parallel configuration file with 2 nodes.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>