Question when extracting procedure using DBMS_METADATA.GET_DDL.

User_U1B1C

Question when extracting procedure using Oracle 12c Version DBMS_METADATA.GET_DDL.

Oracle Database 12c Enterprise Edition Version 12.2.0.1.0

1. If you use double quotation when you create procedure.

CREATE PROCEDURE "TEST"."RESULT1"

BEGIN

  NULL;

END

2. If you don't use double quotes when you create procedure.

CREATE PROCEDURE TEST.RESULT2

BEGIN

  NULL;

END

Extract using "DBMS_METADATA.GET_DDL" in each case.

1. SELECT DBMS_METADATA.GET_DDL('PROCEDURE','RESULT1','TEST') FROM DUAL;

--RESULT

CREATE OR REPLACE NONEDITIONABLE PROCEDURE "TEST"."RESULT1"

BEGIN

 NULL;

END

2. SELECT DBMS_METADATA.GET_DDL('PROCEDURE','RESULT2','TEST') FROM DUAL;

--RESULT

CREATE OR REPLACE NONEDITIONABLE PROCEDURE "TEST"."RESULT2" RESULT2

BEGIN

 NULL;

END

• In the second case, Please help prevent object_name from being printed twice.

User_GSQTY

I have oracle 12.2.0.1 Enterprise on linux 7.9 with no initerim patch and I don't have this issue.

I'm wondering if this is a specific platform / patch bug.

On which platform are you running oracle ?

User_U1B1C

K-1.jpg

K-2.jpg

K-3.jpg

Thanks for reply.

OS platform : RadHat7.9 and CentOS7.9

It seems that object_name is duplicated in the procedure created by the query tool.

Please refer to the attached image.