hello, i have an issue. how to execute immediate a SP from data table.
example :
select source_code from tble_source;
sp_1(:1,:2)
create or replace procedure sp_2(param1, param2) return int as
declare
v_result int:
v_exec varchar(200);
begin
select source_code into v_exec from tble_source;
execute immediate v_exec into v_result using param1, param2;
return v_result;
end
***that code above doenst work, please kindly help. thanks in advance.
Welcome Missgeekcode! 
Sorry you are experiencing this issue.
Are you on the managed or self-hosted service and what version?
We don’t support the “using” clause to substitute values into a string before executing it. So you need to put together a string with the whole command you want, plus parameters.
You could do a REPLACE to substitute parameters :1 and :2. Then EXECUTE IMMEDIATE the resulting string.
hallo, thanks for the reply and i have another problem with execute immediate a SP inside a SP, that is not working with echo inside a SP. please kindly help. thanks.