Message --
Date: Tue, 13 Aug 2002 14:34:13 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Danny Hughes [EMAIL PROTECTED]
Subject: nextval increments by 2 in pl/sql procedure
hello all,
I have a pl/sql procedure that selects the nextval from
There is nothing wrong in what you are doing. It might be that there are lots
of requests for story_transaction_seq.NEXTVAL and by the time you reach the
next line it gets incremented by 1 again(unlikely, but possible).
I suggest you test it when you are sure that there will be no request for
Thanks for your responses,
Not completly sure why it was skipping on a nextval then an immediate currval select
yesterday, but I got with the PHP programmer and re-worked the calling program and
today it is working like expected.
Thanks again.
[EMAIL PROTECTED] 08/14/02 07:53AM
There is
ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Danny Hughes [EMAIL PROTECTED]
Subject: nextval increments by 2 in pl/sql procedure
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence by 2 in a pl
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The problem is
that it incrrements the sequence by 2 in a pl/sql procedure. If I select the nextval
from a sqlplus session, it works fine.
here is partial code that I am using.
PROCEDURE NEWTRANSACTION