Hi,i have a strange problem. My sequence name is not getting recognized inside my insert statement written in String inside my DAO. I am sure the sequence name is right because i executed "select sws_user_sequence.currval from dual" gives me the right value in sql Developer tool. Only thru the java code as written below, the compiler throws a sql exception ORA-02289: sequence does not exist. Here is the code.
If sequence exists for sure then it must be privilege issue. See what userid or schema is used when creating the connection. I am sure the user used for creating connection doesn't have right privilege (SELECT ANY SEQUENCE)