Skip to Main Content

SQL Developer Data Modeler

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.

Name Substitution for Stored Procedure Body?

J-Mar 12 2025

Is it possible to use DDL generation name substitution to substitute user/schema names when referenced by stored procedure bodies?

For example, I have the following stored procedure:

CREATE OR REPLACE PROCEDURE SP_TABLE_1
BEGIN
SELECT * FROM PH_1.TABLE_1;
SELECT * FROM PH_2.TABLE_1;
END;

I set up name substitution to swap out PH_1 for PH_1_SUB and PH_2 to PH_2_SUB and selected “user” as target object.

The DDL had the code to create the correct users, but it did not change the stored procedure body to reflect the new users.

This post has been answered by Philip Stoyanov-Oracle on Mar 24 2025
Jump to Answer

Comments

Post Details

Added on Mar 12 2025
1 comment
31 views