0
I have this process where I save inside a cursor all the other procedures that need to be executed, then I go through the cursor by placing the names of the procedures inside a variable.
How to perform these procedures that are named within the variable+?
CURSOR cur_procedures IS
SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_NAME like
'%P_CES_INTERF_DIMOF_TREE_%' and OBJECT_TYPE IN ('PROCEDURE')
and OBJECT_NAME not like '%P_CES_INTERF_DIMOF_TREE_SPS%'
order by OBJECT_NAME;
Proc varchar(50);
BEGIN
OPEN cur_procedures;
LOOP
FETCH cur_procedures INTO Proc;
EXIT WHEN cur_procedures%NOTFOUND;
END LOOP;
CLOSE cur_procedures;
END;