IBM Integration Bus, Version 10.0.0.9
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
Support for stored procedures
When you call stored procedures
from a map, you must be aware of the following limitations:
Stored procedures from only the following databases are supported:
IBM® DB2®
Oracle
The following entities are not supported in database calls from
a graphical data map:
Stored procedure parameters of type Array
Database user-defined functions
Oracle stored procedures that are contained
within packages
Oracle stored procedures that include IN
or INOUT SYS_REFCURSOR parameters
Stored procedures that return result sets that contain user-specified
column names (column names that do not exist in any table) can be
called, but you cannot include these column names in mappings.