Forum Discussion

rootaren's avatar
rootaren
New Contributor
4 years ago
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 fi...
oracle
SOAP
  • richie's avatar
    richie
    4 years ago
    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
richie's avatar
richie
Community Hero
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
rootaren's avatar
rootaren
New Contributor
4 years ago

Hi richie ,

 

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

 

Thank you!