belka0107 Posted June 30, 2014 Posted June 30, 2014 I'm trying to connect to oracle, but get error:ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specifiedIn sqldeveloper I can fix it if define -Duser.region=US. Where I can set thisoption for jasper server?
hozawa Posted June 30, 2014 Posted June 30, 2014 This is a JasperReports forum. Your question has nothing to do with JasperReports but only on setting up Oracle database. It's better to ask Oracle questions at Oracle forum or at Stackoverflow.
olimpusdrs Posted April 29, 2015 Posted April 29, 2015 I have solved the problem changing the language of my iReport (or TIBCO jaspersoft) tool in the same of that my database. For check try this:select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET','NLS_LANGUAGE', 'LANGUAGE','NLS_TERRITORY', 'TERRITORY') name,value from v$nls_parametersWHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY')[/code]
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now