Hi Folks,
I'm having a problem whit an oracle sequence. I created the sequence using the following DDL:
create sequence MY_SEQUENCE
minvalue 1
maxvalue 9999999
start with 1
increment by 1
nocache;
When I open a database session and run the command:
select MY_SEQUENCE.nextval from dual;
The database give me the right value. But if I open a new database session using the same database user and i run the statement:
select MY_SEQUENCE.currval from dual;
I get an ORA-08002 error.
Any idea?
Thanks a lot !!