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