Re: PL/SQL HELP NEEDED!!!!

From: Barney Gumble <duff.drinker_at_cornerpub.FUDD-SUX>
Date: Thu, 17 Jun 1999 09:59:07 +0200
Message-ID: <3768AACB.5FC92CA0@cornerpub.FUDD-SUX>

So what you are saying, I could make proc like:

Procedure blabla (xxxx NUMBER) AS

BEGIN

        INSERT INTO MyTable (var1, var2)
                VALUES (seq.NextVal, xxxx);

        INSERT INTO NewTable (var1, var2)
                VALUES (seq.CurrVal, xxxx);
... and so on...
        COMMIT;

END; What if there are several users with the same logon ID?

    BG :O)

Thomas Kyte wrote:

> currval and nextval are SESSION specific. When you get a nextval -- currval
> will also return YOUR currval -- never anyone elses. currval would be utterly
> useless if it returned anything other then your last NEXTVAL...

--
"Your infatuation is based on a physical attraction. Talk to the woman and you'll realize you have nothing in common. >>>BURP!!!<<<"

---

Replace ".FUDD-SUX" with ".com" to reply. Received on Thu Jun 17 1999 - 02:59:07 CDT