cancel
Showing results for 
Search instead for 
Did you mean: 

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705

SOLVED
Highlighted
New Contributor

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.

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Hero

Re: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705

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
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta

View solution in original post

2 REPLIES 2
Highlighted
Community Hero

Re: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705

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
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta

View solution in original post

Highlighted
New Contributor

Re: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705

Hi @richie ,

 

This happens in every query. I did the suggestion from stackoverflow --- changing the regional settings, both country and format.

 

Thank you!

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors