I have a procedure which check whether another procedure is exist, if exists, then use execute immediate to run the procedure.
select count(distinct name) into l_proCount from user_source where type = 'PROCEDURE' and name like '%LC_DELETEMETADATAFORPROCESS%';
if(l_proCount > 0)then
execute immediate 'LC_DELETEMETADATAFORPROCESS(2111,1);';
But this not works, it complains error in the execute immediate line.
How to solve this? Any suggestions are welcome, thank you.