ALTER TYPE Encounters PLS-00719 While Modifying Length of Attribute

(Doc ID 2295713.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
PL/SQL - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Type defined as VARCHAR2(10) and created with Byte Semantics encounters error while trying to alter it to VARCHAR2(10 CHAR).

This issue is specific to the attributes which are not defined explicitly as either CHAR or BYTE. In the above example, obj_byte is defined as VARCHAR2(10 byte) and  obj_char is defined as VARCHAR2(10 char). These two attributes are independent of the session level NLS_LENGTH_SEMANTICS setting. 

Changes

 

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