Sunday, December 15, 2013

ORA-02289

This was tested on Oracle 11.2. You can create a sequence and select the next value from it like this: 

SQL> create sequence seq1
  2  /
 
Sequence created.
 
SQL> select seq1.nextval from dual
  2  /
 
   NEXTVAL
----------
         1
 
SQL> 

… but if you try to use a sequence which does not exist, you get an ORA-02289: 

SQL> select blah.nextval from dual
  2  /
select blah.nextval from dual
       *
ERROR at line 1:
ORA-02289: sequence does not exist
 
SQL>

No comments: