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.