NLS Specific Characters (non-ASCII) Display Incorrectly in Reports Output when the Parameters are Passed from a DB Procedure Using srw.run_report and srw.add_parameter builtins (Doc ID 1496187.1)

Last updated on MARCH 31, 2021

Applies to:

Symptoms

When using a database procedure to run a Report with the database installed SRW package, e.g. using the following command :

- myident := system.srw.run_report(myplist);

The language specific characters (e.g.  č, š, ž.) added to the parameter list via srw.add_parameter are displayed incorrectly in Reports output.

The same characters are displayed correctly if the report is called via RUN_REPORT_OBJECT instead of a srw.run_report. This happens even when the DB and Reports Server side NLS_LANG values are set correctly to handle these characters, e.g.

The Database NLS_CHARACTERSET is AL32UTF8.
The NLS_LANG for Reports Server is set to SLOVENIAN_SLOVENIA.EE8MSWIN1250

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.