Re: Sequence error

If you create a sequence with these options:

create sequence euloneowner increment by 1 start with 0 minvalue 0 nocache;

you can then execute:

select euloneowner.nextval from dual;

thus initializing the sequence to 0. You are now free to call currval or nextval as needed without getting errors or using sequence numbers (if that was you goal)

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!