Forum Discussion

rootaren's avatar
rootaren
New Contributor
5 years ago

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
    5 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
5 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
  • rootaren's avatar
    rootaren
    New Contributor
    5 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!