I'm receiving the error below in an ADF application, but I'm hoping a database expect can help me with the SQL error it contains. The application appears to executing the following SQL code:
UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 50 WHERE SEQ_NAME = 'SEQ_GB_ID'
and getting the error:
ORA-00942: table or view does not exist Error Code: 942
when I run the above query it SQL Developer, I get the same error. However when I run the following:
alter sequence SEQ_GB_ID increment by 50;
This works fine.
Can anyone tell me the difference between the two? The sequence is obvious there, since I can increment it (also when I try and create another with the same name it tell me it's already in use). Also when I select * from SEQ, I can see it's there with an increment_by value of 50.
Any help would be appreciated, thanks,
Ben
[error]
JBO-29000: Unexpected exception caught: javax.ejb.EJBException, msg=Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.3.0) (Build 070608)): oracle.toplink.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-00942: table or view does not exist Error Code: 942 Call:UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 50 WHERE SEQ_NAME = 'SEQ_GB_ID' Query:DataModifyQuery(); nested exception is: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.3.0) (Build 070608)): oracle.toplink.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-00942: table or view does not exist Error Code: 942 Call:UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 50 WHERE SEQ_NAME = 'SEQ_GB_ID' Query:DataModifyQuery()
[error]