Hi Fanny,

You can use the views DBA_SEQUENCES or USER_SEQUENCES. There is a
LAST_NUMBER column which gives the last value used by the sequence. If the
sequence is cached, then this will be the number of the highest value in
cache rather than the last number actually used.

Also, you cant set this value other than by using the nextval operator.

You can use this for reporting though, if that's what you need.

John.

-----Original Message-----
From: Fanny Edison
[mailto:oracledba-ezmlmshield-x77386631.[Email address protected]
Sent: 28 July 2006 08:30
To: LazyDBA Discussion
Subject: object as parameter

Dear Friends,



Is there any other way to access sequence next value beside using
sequence.nextVal function?

I am asking this since I need to get sequence next value from Java program,
but in the same time the sequence name itself is a parameter.



Regards,


Fanny Edison








--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page