ALTER TYPE Encounters PLS-00719 While Modifying Length of Attribute
Last updated on AUGUST 14, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
PL/SQL - Version 188.8.131.52 and later
Information in this document applies to any platform.
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.
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