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.