DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle reports not supporting WCHAR and WVARCHAR

714978Jul 31 2009

I have been using Oracle Reports Builder 10g (Report Builder 9.0.4.0.33) to test against an ODBC backend database via the provided jdbc-odbc bridge, this has been working well but recently the server backend changed to be UTF-8 compatible and as a result now returns the WCHAR and WVARCHAR types (ODBC types -8 and -9). These cause an error in the Report Designer

REP-0069 Internal Error
JDBCPDS-62013: The column type WCHAR used in the query/procedure is not supported by Reports JDBC Query.

I have my NLS_LANG and DEVELOPER_NLS_LANG set to ENGLISH_UNITED KINGDOM.UTF8.

Is there any way to enable the support for WCHAR/WVARCHAR in the Reports Builder?

Regards,

Adam.