Evaluate with Procedures
Evaluate can be used only with function. Since Evaluate is expected a value to be returned.
Workaround: Now to use Evaluate with a Procedure; we can have a wrapper function which calls this procedure.
Sample Function :
Evaluate('function_1(%1)', Tab_Name.Col_Name);
Function function_1(PARAM_1 VARCHAR2) return NUMBER
Begin
proc_1(PARAM_1);
return 1;
end f1;
Procedure proc_1(Param_1 varchar2)
As
Begin
/*
Code to achieve some functionality
*/
end p1;
-----------------------
