Jane,
With this same configuration, I saw significant performance
degradation when calling a custom-defined oracle function as part of
the object syntax. The function had alot of if/then/else logic; I
ended up using a series of decodes in the object syntax instead.
Obviously, it depends alot on what exactly your function is doing, but
this was my experience.
Jason Beard
-------------------------------------------------------------
I have some quite complex SQL to perform for some of my objects. Currently
I’ve got this defined in a Function written in PL/SQL and stored on the
database. For some of them it may be possible to craft the SQL into the
object definition.
Listserv Archives (BOB member since 2002-06-25)