Support for External Function Activities
Oracle Workflow Builder now supports function activities that are defined by PL/SQL procedures as well as external functions. To support external function activities, Oracle Workflow integrates with Oracle8 Advanced Queues. Oracle Workflow enqueues data for the external function in the 'Outbound' queue. Once the external function completes, it must enqueue the appropriate return information in the 'Inbound' queue.
To Create a Function Activity
Workflow Queue APIs