ALTER TYPE Encounters PLS-00719 While Modifying Length of Attribute
(Doc ID 2295713.1)
Last updated on FEBRUARY 23, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
PL/SQL - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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.
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