Java Code does not recognize my sequence name
posted 8 years ago
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.