Bugs in Developer 2000?

[Quoted] I have a simple code

[Quoted]      select liu.itemid_sequence.nextval from dual;

[Quoted] [Quoted] for a button. I am puzzled by the so-called internal error (database error) during compiling. I do not have a formal explanation but I have the following workaround:

1. Use SQLPlus to login to Oracle server
2. Create my own sequence like this: create sequence itemid_sequence increment by 1 start with 10011;
3. I change the code for Create button as follows: select itemid_sequence.Nextval from dual;
4. Then I get another error saying something about Nextval. So I change Nextval to nextval
5. I now can compile the code correctly.
6. I finally change the code back to my original one: select liu.itemid_sequence.Nextval from dual;
7. It stills compiles without errors

Does anybody out there have explanation for the above?.

--



*************************************************************

Liping Liu, Ph.D.
Assistant Professor
Information Systems
Susquehanna University
Selinsgrove, PA 17870
Tel: 717-372-465
Fax: 717-372-4491
Email: liu_at_infosys.susqu.edu
URL: http://infosys.susqu.edu/liu


*************************************************************