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 (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 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 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 (v_storyid IN story.story_id%type, > > v_transid OUT story_transaction.trans_id%type > >) IS > > > >BEGIN > > select story_transaction_seq.nextval into v_transid from dual; > >..... > >END > > > >for debugging purposes, I made that code look like... > > > >PROCEDURE NEWTRANSACTION (v_storyid IN story.story_id%type, > > v_transid OUT story_transaction.trans_id%type > >) IS > > > >v_value1 NUMBER; --debug code > >v_value2 NUMBER; --debug code > > > >BEGIN > > select story_transaction_seq.currval into v_value1 from dual; --debug > code > > select story_transaction_seq.nextval into v_transid from dual; > > select story_transaction_seq.currval into v_value2 from dual; --debug > code > > > >..... > >END > > > > > >when I ran this, v_value1 had a 200, v_transid had a 201, and v_value2 > had > >a 202 > > > >taking the debug code out and hitting that procedure with a web page will > >increment the v_transid by 2 each refresh of the page. > > > >am i doing something wrong? I can't find any information on the web related > >to this issue. > > > >TIA > > > > > >Danny Hughes > >DBA > >Knobias.com > >601-978-3399 x103 > >[EMAIL PROTECTED] > >www.knobias.com > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Danny Hughes > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > ---------------------------------------------------- > Torben Holm > Miracle A/S > > Mobil : +45 2527 7104 > [EMAIL PROTECTED] > http://miracleAS.dk > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
