Forum Stats

  • 3,872,586 Users
  • 2,266,452 Discussions
  • 7,911,259 Comments

Discussions

ORA-00604 and ORA-01804 errors when try to create connection

Hello there,

I hope that you are doing well. When attempting to create a connection I am getting the following errors:

Error opening connection 'ARMS QA eXaCC'.Details: ORA-00604: error occurred at recursive SQL level 1

ORA-01804: failure to initialize timezone information

I have seen that with SQL Developer in order to resolve this issue you need to insert the following into \sqldeveloper\bin\sqldeveloper.conf:

AddVMOption -Duser.region=US

but i'm not sure where this needs to go for the Oracle DB extension in VS Code. Any suggestions would be greatly appreciated.

Thanks!!