One of those things that can irritate you for more than you can care of: the mix up in dates. That’s an old story for those dealing with the Oracle Db but in our case, that was something that bothered us for more than a week before we found out that we were missing the environment variable NLS_DATE_FORMAT in our report server setup.<\/p>\n
<\/p>\n
In our old C\/S forms 6i setup, we used to have 2 ways of getting reports out.\u00a0 Either Preview or Printer with a submission form that has all the report parameters.\u00a0 In most cases, we needed a START DATE<\/strong> and an END DATE<\/strong> . Those were always supposed to be in the format DD\/MM\/YYYY<\/strong> since we use FRENCH_CANADIAN as our NLS_LANG. In the add_parameters statement, a to_date<\/strong> with the proper format was systematically used. However, in the report module, the receiving parameter was setup as CHARACTER with length 10. That was working fine in the C\/S version. Remember that each user could have his own report on his own machine. The registry in this case had a value setup for NLS_DATE_FORMAT and NLS_LANG.<\/p>\n On 10g, this was giving us a TERMINATED_WITH_ERROR message each time the report was called. One way to fix the error was to set the user parameter for the dates as DATE with the proper format (DD\/MM\/YYYY).<\/p>\n