Everything goes ok, but i have to change the NLS_LANG because the decimal and number separator are wrong. The problem is that this report server is common with other applications, and I cannot change the reports.sh with my desired NSL_LANG.
So I'm trying to change the NLS_LANG to some reports, and let others with the default reports.sh.
My first attempt was create a new rwclient.sh (rwclient_sp.sh) with this:
NLS_LANG=SPANISH_SPAIN.WE8ISO8859P1; export NLS_LANG
exec $ORACLE_HOME/bin/rwclient "$@"
but don't worked at all. the generated pdf still has the number format wrong.
Other question, why i have to shut down and re-up report server if I change the nls-lang in reports.sh?
Can i make 2 differents reports.sh (e.g. reports.sh and reports_sp.sh) with two differentes NSL_LANG?
Hi, dsegard, thanks for the response. But i don't want use jobs, and not submit the URL to Reports Server like this
I want to generate with my sh in unix, send to certain output, and use rwclient...
I try your solution. It worked, but I have to:
1) Change the reports.sh and comment this:
##NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
2) Change the my_report_server.conf and add
<envVariable name="NLS_LANG" value="SPANISH_SPAIN.WE8ISO8859P1"/>
<envVariable name="NLS_LANG" value="AMERICAN_AMERICA.WE8ISO8859P1"/>
3) Add in the engines in the report_server.conf the default environment:
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="2" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="90000" defaultEnvId="default">