IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite > Overview of IBM WebSphere Adapter for Oracle E-Business Suite > Technical overview

Stored functions overview

The Oracle database supports stored functions in addition to stored procedures. Stored functions are like stored procedures except that they always return a value. The adapter supports them in a similar manner.

The adapter supports stored functions that a user creates with the CREATE FUNCTION statement. Although this type of function is sometimes called a user-defined function (UDF), that term more typically refers to a Java™ stored function or procedure, which the adapter does not support.

A function call has the following syntax:

? = call FunctionName parameter_list

Contrast this to a stored procedure call, which has the following syntax:

call SPName parameter_list

You specify the attribute that contains the returned value by using the ReturnValue business object application-specific information.

Technical overview of IBM WebSphere Adapter for Oracle E-Business Suite