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

Last updated on JUNE 22, 2017

Applies to:

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

Symptoms

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


Changes

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

Cause

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 hundreds of Community platforms