surajitmitra78
08-14-2004, 08:40 AM
Hi,
I have problems in executing some formulas which is stored in variables.
The scenario is as follows:
/* ---- */
Declare
ls_formula varchar2(50);
a number(3) := 10;
b number(3) := 20;
ll_result number(3) := 0;
Begin
ls_formula := 'a + b + 15 - 20 + 10';
/* --- Require Help here */
ll_result := <execute the formula variable i.e., ls_formula>;
Dbms_output.put_line ('Result : ' || ll_result);
End;
How to execute the formula variable to give me the resulting value.
I have problems in executing some formulas which is stored in variables.
The scenario is as follows:
/* ---- */
Declare
ls_formula varchar2(50);
a number(3) := 10;
b number(3) := 20;
ll_result number(3) := 0;
Begin
ls_formula := 'a + b + 15 - 20 + 10';
/* --- Require Help here */
ll_result := <execute the formula variable i.e., ls_formula>;
Dbms_output.put_line ('Result : ' || ll_result);
End;
How to execute the formula variable to give me the resulting value.