I'm not sure, but would concurrency be an issue here?
With Warm Regards,
Manav.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 14, 2002 5:28 AM
> Where do you call your procedure?
> If you are running the code through IAS you
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
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 the
Where do you call your procedure?
If you are running the code through IAS you (ias) will start more than one
session (if you are using SSO), so depending on where you are calling your
procedure it migth be called more than once. Could you please give some
more information.
/torben
>-- Original Me
