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.