How to execute immediate a procedure from table in SP

Help
1

hello, i have an issue. how to execute immediate a SP from data table.
example :

select source_code from tble_source;

source_code

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.

2

Welcome Missgeekcode! :wave:
Sorry you are experiencing this issue.
Are you on the managed or self-hosted service and what version?

3

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.

1 Like
4

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.