Validating Math Equations

[brhynold]

Hello all

I need to write a procedure that accepts a math equation and verifies that the equation is valid.

i.e 2x+5*5x

This equation is in fact valid in Oracle but it does not do the math properly. If x is equal to 1 then the equation gets processed as follows

21+5*51 instead of 2*1+5*5*1

Has anyone ever dealt with a situation like this. I need to be able to scan the equation and check for a number infront of the x. All other situations the equation is invalid anyway.

Thanks in advance for any help you can provide

[Shestakov]

create or replace
function eval_expr(p_expr varchar2) return boolean is
begin
execute immediate 'select '||p_expr||' from dual';
return true;
exception when others then return false;
end;
/

[pando]

dupe bummer

[brhynold]

Thanks

That's alot simpler than the code I was working with