Select s.currval from dual
ORA-08002: sequence S.CURRVAL is not yet defined in this session
CURRVAL doesn't represent anything global about the sequence number generator. It only represents the value returned to your session (the database session processing the current statements) the last time you called NEXTVAL for that sequence
Solutions :
#1 before using CURRVAL you should call NEXTVAL .
#2 You can get the current value of the Sequence by querying DBA_SEQUENCES , which is Last_number.
1 comment:
sahi hain gurudev...
Post a Comment