User Defined Type(UDT) with 'ACCESSIBLE BY' Clause Cannot Be Wrapped (Doc ID 3006221.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Symptoms

The definition of an User Defined Type(UDT) object with 'ACCESSIBLE BY' clause used in it cannot be obfuscated using 'wrap' command-line utility or the sub-program DBMS_DDL.create_wrapped.

When the UDT definition is wrapped using 'wrap' command-line utility, it doesn't raise any error but the output file('oname') contains the same unwrapped code as provided in input('iname').

When the UDT definition is wrapped using the sub-program DBMS_DDL.create_wrapped, it raises the error ORA-24230: input to DBMS_DDL.WRAP is not a legal PL/SQL unit

The issue can be demonstrated using a simple testcase given below.

The UDT can be wrapped if the 'ACCESSIBLE BY' clause is removed from the definition.

Changes

This is first time an UDT with 'ACCESSIBLE BY' clause is attempted to be wrapped.

Cause

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