Sequences

[nik_flash]

Hi All,
I m facing a problem when I am trying to access a sequence currval
eg SEQ_XYZ.CURRVAL in a query like
select SEQ_XYZ.CURRVAL from dual ;
an error is raised
ORA-08002: sequence SEQ_ST_ORDER_ID.CURRVAL is not yet defined in this session
but when I print nextval of this sequence & then its currval then it runs fine.
Any idea.

regards
Nik

[andrejm]

When you start session you need first to query for nextval and then currval

there is no currval of sequence in your session when you start session

SELECT SEQ_XYZ.NEXTVAL FROM dual ;

SELECT SEQ_XYZ.CURRVAL FROM dual ;

[nik_flash]

thanx a lot got it.


When you start session you need first to query for nextval and then currval

there is no currval of sequence in your session when you start session

SELECT SEQ_XYZ.NEXTVAL FROM dual ;

SELECT SEQ_XYZ.CURRVAL FROM dual