ORA-00604

If you encounter ORA-00604 (ORA-00604: error occured at recursive SQL level 1) in SQLDeveloper while connecting to Oracle 11g database; here’s what needs to be done:

Edit

SQL_DEV_INSTALL_DIR/sqldeveloper/bin/sqldeveloper.conf

, and add the following line:

# Set timezone for IST
AddVMOption -Duser.timezone="+05:30"

Another option (if you know the region code) is to provide the TZ code instead:

AddVMOption -Duser.timezone=CET

Restart SQLDeveloper and the error should be gone!