My Oracle Support Banner

Double Byte Characters Are Not Accounted For In Max_character Restriction (Doc ID 2279522.1)

Last updated on MARCH 07, 2019

Applies to:

Oracle Utilities Network Management System - Version to [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version to [Release 1.12 to 2.3]
Information in this document applies to any platform.


On a desktop that is configured to use double-byte characters, the character count validation in web workspace/web switching does not appear to work.

For example, in web switching, the switching request operator field is configured for a maximum of 20 characters.  This matches the database schema.  varchar2(20).
If you enter 15 double-byte characters in the field and press Save, web switching does not give an error.  Instead, the save fails and the database gives an ORA-12899.

The issue can be reproduced at will with the following steps:
1. Copy/paste 20 double byte characters into the switching request operator field.
2. It will fail with the error ORA-12899


 The desktop/operating system is configured to use double-byte characters.


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

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

In this Document

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