Solved
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705
I am trying to retrieve a column in Oracle. However, I encounter the below error:
-> java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
Using the default connection string and driver used: oracle.jdbc.driver.OracleDriver.
Thank you.
- Hey rootaren,
Does this occur for every query? Im guessing it does (its a problem due to a conflict with regional/language settings), but if you execute:
SELECT sysdate FROM dual;
Do you still get the NLS error response?
Is oracle installed on your local machine or is it remote?
The following stackoverflow indicates how to fix your issue.
https://stackoverflow.com/questions/1629327/ora-00604-ora-12705
Nice one,
Rich
