Re: user-defined functions

From: <andrewf_at_jaredgroup.com>
Date: Wed, 30 Dec 1998 14:38:17 GMT
Message-ID: <76ddsp$okg$1@nnrp1.dejanews.com>

In article <3689C79F.9AB8EC77_at_sybrandb.demon.nl>, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

> In the past I have been working with user-defined functions in selects which
> were issuing additional selects (I didn't design them luckily). The
> performance of this was usually quite bad.

User defined functions should be designed carefully. There are situations you just need these additional selects and the function can simplify your code and give better performance.

My concern is, it is said that user defined functions are not subject to Oracle read consistent model. If so, be more careful as you may get inconsistent result.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 30 1998 - 08:38:17 CST