Re: sql*forms user exit for evaluation of transcendental functions
Date: Sun, 3 May 1992 14:11:30 GMT
Message-ID: <1992May3.141130.22101_at_hounix.org>
In article <1992May1.022340.2354_at_ml.csiro.au> peter_at_ml.csiro.au (Peter Campbell) writes:
>We need transcendental functions within sql*forms. I though it would
>be nice to have a general purpose user exit that could evaluate statements
>involving such functions e.g.
>
> user_exit ('evaluate :age = log(1 - :length / 169.5)');
>
>Has anyone done anything like this on a Sun?
>
>Peter Campbell peter_at_ml.csiro.au
>CSIRO Marine Labs, Hobart, Australia
I wrote some code that computes natural logarithms and exponentials using only PL/SQL intrinsic math operators. It does numeric approximations using algorithms that are good to 16 decimal places. Not a general purpose solution, but it avoids user exits (which was my client's requirement). If you want a copy, e-mail me, I will attempt to send.
--Bill -- ------------------------------------------------------------------------- William L. Pribyl | Internet: wlp_at_hounix.org DataCraft, Inc. | or : 70451.2315_at_compuserve.com Houston, TX Voice: 713-526-7345 |--------------------------------------Received on Sun May 03 1992 - 16:11:30 CEST