RE: How Can I get A sequence Current Value in PROC

From: Lowes, Harry (NESL-IT) <Harry.Lowes_at_northern-electric.co.uk>
Date: Mon, 26 Nov 2001 08:18:42 -0800
Message-ID: <F001.003CCDCA.20011126080548@fatcity.com>

Afternoon,

I had always assumed that this was because, before you get the next number for a sequence using NEXTVAL, there ISN'T a current value. There is only the last number generated, visible in the dictionary. NEXTVAL initialises the current value, setting it to (LAST_NUMBER + INCREMENT_BY). This becomes the current value to be used by that transaction. Other transactions that have not used NEXTVAL do not have a current value from that sequence (but can look at the value in the dictionary).

Thanks,

Harry Lowes
Database Administrator,
npower Northern Limited
mailto:harry.lowes_at_northern-electric.co.uk

-----Original Message-----
Sent: 26 November 2001 15:00
To: Multiple recipients of list ORACLE-L

Or I think you can query the dictionary

SELECT last_number

        INTO <your_variable>
        FROM user_sequences
        WHERE sequence_name = UPPER(<your_sequence>)

I don't know why it's necessary to use nextval, but they state this in the documentation.

Iulian

-----Original Message-----
Sent: Monday, November 26, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L

Does anyone know why Oracle forces you to use NEXTVAL before doing CURRVAL. I would think sometimes you would want to use CURRVAL without incrementing sequence first.

Thanks
Rick

-----Original Message-----
Sent: Monday, November 26, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L

You can use another pseducolumn CURRVAL but you must use at least once per session the NEXTVAL before using the CURRVAL or else you would get the ORA-08002 error.

...
SELECT <your_sequence>.CURRVAL INTO <your_variable> FROM dual; ...

HTH
Iulian

-----Original Message-----
Sent: Monday, November 26, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L

This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department.

when writing a program PROC <sequenceName>.NEXTVAL points to the next value of a sequence, is there anything like <sequenceName>.SOMETHING that returns current value of sequence.

Thanks

Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: ehsan sinavalda
INET: ehsanoracle_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

**
The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Iulian.ILIES_at_mobil-rom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound by its terms.

The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail postmaster_at_northern-electric.co.uk.

This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on.

No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it.

Northern Electric plc
Carliol House
Market Street
Newcastle-upon-Tyne
NE1 6NE
Registered in England and Wales: Number 2366942

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Lowes, Harry (NESL-IT)
INET: Harry.Lowes_at_northern-electric.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------