My Oracle Support Banner

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 11.2.0.1 and later
PL/SQL - Version 11.2.0.1 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.

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

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
Symptoms
Changes
Cause
Solution
References


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