Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SEQUENCE is not same between sessions

694537Feb 15 2011 — edited Feb 15 2011
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 !!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2011
Added on Feb 15 2011
9 comments
3,989 views