Previous  Next          Contents  Index  Navigation  Glossary  Library

Defining Functions

Many functions are supplied with Oracle FastFormula. See: Functions. In addition, you can create other functions as you require for use by Oracle FastFormula. Doing this involves two steps: creating a new PL/SQL function, then registering it in the system using the Define Function window.

You need to be aware of two restrictions when creating user defined functions. These are:

Registering the Function

You register a new function by naming and defining it, then creating contexts and parameters for it. Contexts are environment values that do not get passed to the function.

Where a function requires a mixture of contexts (from the FF_CONTEXTS table) and parameters, the contexts should be listed first in the function header followed by the function parameters. Only the function parameters, however, need to be used to call the function from FastFormula.

For example, a function requires eight values: three contexts and five parameters. All eight values are listed in the function header but only the five parameters are used to call the function.

There are three classes of functions you can register:

To register a new function for Oracle FastFormula:

To enter context usage and parameter information:

See Also

Oracle FastFormula Overview

Oracle FastFormula Reference

         Previous  Next          Contents  Index  Navigation  Glossary  Library