Jump to content

Recommended Posts

Posted

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 specified

In sqldeveloper I can fix it if define -Duser.region=US. Where I can set thisoption for jasper server?

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted

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.

  • 9 months later...
Posted

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]



 

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...