Recent content by dsarda

Mufasa, That worked fine - Thank you very much ! -- dnyanesh

Thanks Dan - I tried execute immediate - however i cannot use the using clause to bind variables because the number and order of variables is dynamic depending on the scenario. i think i am just going to parse the sql and bind variables if they exist in the formula and then execute immediate...

Dan, The formulae are numerous and required to be dynamic so that system administrators can keep adding new ones as and when required without having to make changes to the procedure. This is the code snippet: _____________________________________________________ select...

Dan, I have to calculate a value and the formula for it's calculation changes in terms of expression and data required depending on certain business rules. e.g: sum = a*b + c if business rule 1 is met sum = a + d if business rule 2 is met and so on and so forth. Thanks -- dnyanesh

I have a formula (e.g. :a*:b) as a record in a table. In my stored procedure, I retrieve this formula and replace ':a' and ':b" with the appropriate values. Now I want to insert the result of this expression (a*b) into a table. I have tried a few approaches and they result in the...