Click to See Complete Forum and Search --> : Variable Substitution


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.