Dinamik Fonksiyon Çalıştırma

CREATE OR REPLACE function cagir (func_adi varchar2,parametre_degeri varchar2) return varchar2 as
sql_string varchar2(100);
func_name varchar2(30);
--a varchar2(100);
param number;
xxx number;
begin
func_name :=func_adi;
param := 2;
--a:= alan_hesap(4);
sql_string := func_name ||'('||param||')';

sql_string := 'SELECT '||sql_string || ' FROM DUAL';
DBMS_OUTPUT.PUT_LINE ('sql_stirng='||sql_string);
execute immediate sql_string into xxx;

--execute immediate 'SELECT alan_hesap(2) FROM DUAL' into xxx ;
return XXX;
end;
/
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
CREATE OR REPLACE FUNCTION ALAN_HESAP(i NUMBER)
RETURN NUMBER AS
alan NUMBER;
BEGIN
alan :=i*i;
DBMS_OUTPUT.PUT_LINE(alan);
RETURN alan;
END;
/
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
CREATE OR REPLACE procedure calistirici is
cagirici varchar2(1000);
parametre_degeri varchar2(100);
func_adi varchar2(30);
begin
select paramater_value, paramater_name into parametre_degeri, func_adi from process_task_parametre where job_id = 11;
cagirici := cagir(func_adi,parametre_degeri);
end;
/