Re: INSERT w/ RETURNING clause using DBD::Oracle

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Mon, 23 Aug 1999 18:59:34 +0100
Message-ID: <3pfP4AAGwYw3EwgN@ahardy.demon.co.uk>

In article <7prjvh$2b4$1_at_nnrp1.deja.com>, paulsingh_at_my-deja.com writes
>Also, I suspect that this solution wouldn't hold-up with multiple
>users?? e.g., what if User2 inserted into the same table after User1
>did a SELECT on the sequence but before User1's INSERT statement?

Nextval and currval are session specific - they are true for the session and so not affected by multiple users.

Andy
--
Andy Hardy. PGP key available on request

Received on Mon Aug 23 1999 - 12:59:34 CDT