too bad COPY & PASTE are broken for you.
08002, 00000, "sequence %s.CURRVAL is not yet defined in this session"
// *Cause: sequence CURRVAL has been selected before sequence NEXTVAL
// *Action: select NEXTVAL from the sequence before selecting CURRVAL
SQL> SELECT UTL_RECOMP_SEQ.CURRVAL FROM DUAL;
SELECT UTL_RECOMP_SEQ.CURRVAL FROM DUAL
ERROR at line 1:
ORA-08002: sequence UTL_RECOMP_SEQ.CURRVAL is not yet defined in this session
SQL> select last_number from dba_sequences where SEQUENCE_NAME = 'UTL_RECOMP_SEQ';
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.