Alex Rivera | Logout

Oracle: sequence MySequence.currval is not yet defined in this session

Asked 2009-04-30T21:41:37.760
55

What does this mean, and how can I get around it?

SELECT MySequence.CURRVAL FROM DUAL;

Result:

ORA-08002: sequence MySequence.CURRVAL is not yet defined in this session

oracle-database sequence
Edit
Report

1 Answer

21

use this

select sequence_name, 
   to_char(min_value) min_value,
   to_char(max_value) max_value, 
   increment_by,
   cycle_flag, 
   order_flag, 
   cache_size, 
   to_char(Last_number) last_number
from user_sequences
where sequence_name='MYSEQUENCE'
answered 2010-03-04T21:50:07.857

Your Answer