Re: sql*forms user exit for evaluation of transcendental functions

From: William L. Pribyl <wlp_at_hounix.org>
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

Original text of this message