I've inherited another developer's code and this query:
select id_seq.nextval from dual
Is causing this error:
ORA-02289: sequence does not exist
02289. 00000 - "sequence does not exist"
*Cause: The specified sequence does not exist, or the user does
not have the required privilege to perform this operation.
*Action: Make sure the sequence name is correct, and that you have
the right to perform the desired operation on this sequence.
Error at Line: 1 Column: 7
I'm pretty sure the user has the required privileges to run this query. How can I fix this?