3 Replies Latest reply on Jul 10, 2014 9:18 AM by Lee007

    SQL Developer 4.0.2 - Can't connect to Oracle because of a timezone error


      Hi there,


      First of all I am a newbie to SQL Develper.  I've used toad and it works without having to setup a timezone.  I have however setup the appropriate time zone in the sqldeveloper.conf file but am still get the same error below.


      An error was encountered performing the requested operation:

      ORA-00604: error occurred at recursive SQL level 1

      ORA-01882: timezone region  not found

      00604. 00000 -  "error occurred at recursive SQL level %s"

      *Cause:    An error occurred while processing a recursive SQL statement

                 (a statement applying to internal dictionary tables).

      *Action:   If the situation described in the next error on the stack

                 can be corrected, do so; otherwise contact Oracle Support.

      Vendor code 604


      How can I fix this?


      Your help will greatly be appreciated.