Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Question when extracting procedure using DBMS_METADATA.GET_DDL.

User_U1B1CJul 19 2021

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.

Comments

Processing

Post Details

Added on Jul 19 2021
2 comments
233 views