My Oracle Support Banner

The PL/SQL Toolkit htp.p Package Generates ORA-20000: WSGL.LayoutRowEnd Errors When Rendering Special Characters (Doc ID 1543751.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle HTTP Server - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After a database upgrade, when the PL/SQL toolkit procedure 'htp.p' is called to render an accented character such as 'Ã' the following error is generated:


The issue can be reproduced by executing the procedure via the Oracle HTTP Server mod_plsql module, or by directly calling the procedure from SQL*Plus.

Changes

The Database was upgraded from Oracle 9 to Oracle 11.2.0.2.

As part of the upgrade, the character set was changed from WE8ISO8859P1 to AL32UTF8

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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