Forum Stats

  • 3,814,095 Users
  • 2,258,820 Discussions
  • 7,892,564 Comments

Discussions

Format of Report parameter (date datatype) gets changed for Right to Left

Shehzeer vp
Shehzeer vp Member Posts: 5 Red Ribbon
edited Feb 13, 2019 11:28PM in Reports

Hi,

I am using Forms and reports 12c with Weblogic as server.

I am calling a report from Form using "run_report_object" and "Web.show_document".

I am passing a Date value from the Form to Report . --Date in this case is '18-jan-2001'

When I run the report, I get the error - REP-0091, REP-0613 and ORA-03147.

I have tried all different Input masks (for parameter in report) and tried changing to different formats while sending from Forms. But not working.

The report direction is "Right to Left". But even if I change it to "Left to right", it doesnot work.

If I change the User parameter from Date to Character, it works.

Tagged:

Answers

  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member Posts: 298 Employee
    edited Feb 13, 2019 3:26AM

    What is the NLS_LANG used in the Report Server?

  • Shehzeer vp
    Shehzeer vp Member Posts: 5 Red Ribbon
    edited Feb 13, 2019 11:28PM

    Btw, I forgot say- We are displaying Arabic characters in reports and Report direction is Right to Left.

    So I have set nls_lang as "ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256".

    It is set in rwserver.conf as :

    <environment id="AR">

    <envVariable name="NLS_LANG" value="ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256"/>

       </environment>

    <engine id="rwEng" class="oracle.reports.engine.EngineImpl" maxEngine="1" minEngine="1" engLife="50" defaultEnvId="AR" >

    FYI, When I revert nls_lang to "AMERICAN_AMERICA.AR8MSWIN1256", report runs fine, but Right to Left direction is lost, We want R to L direction also.