My Oracle Support Banner

Dbms_Metadata.Get_ddl Hangs for Wrapped PL/SQL Procedures with Comments (Doc ID 2731415.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 21.1 [Release 12.2 to 20.0]
Information in this document applies to any platform.

Symptoms

DBMS_METADATA.GET_DDL hangs for wrapped pl/sql procedures.
This happens starting with 12.2 and it can be reproduced using below:

create or replace procedure
-- /*
p wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
22 55
IazGQkLEzsce5O+cGzb+Ubu6WMowg5nnm7+fMr2ywFwWabh0i8DAMv7ShglppZmBCC2LwIHH
LcmmpuwB560=
/

select dbms_metadata.get_ddl('PROCEDURE','P','SYS') from dual;

If the comment is removed and the procedure created using below code, the dbms_metadata.get_ddl works fine:

create or replace procedure
p wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
22 55
IazGQkLEzsce5O+cGzb+Ubu6WMowg5nnm7+fMr2ywFwWabh0i8DAMv7ShglppZmBCC2LwIHH
LcmmpuwB560=
/

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
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.