IBM Transformation Extender Oracle adapter does not support SYS_REFCURSOR return type in an Oracle stored procedure / function - United States Oracle Adapter Unsupported datatype SYS_REFCURSOR TECHNOTE (TROUBLESHOOTING)

PROBLEM(ABSTRACT)
 When using the IBM WebSphere Transformation Extender (WTX) / IBM Transformation Extender (ITX) Oracle adapter to call a stored procedure / function with a REF_SYSCURSOR return type, a failure of "Unsupported datatype returned is being treated as text" occurs. 

SYMPTOM
The Oracle database adapter log (.dbl) reports the following error:

Unsupported datatype returned is being treated as text.


CAUSE
SYS_REFCURSOR is not a valid datatype as a return from an Oracle stored procedure call using the WTX / ITX Oracle adapter.

ENVIRONMENT
IBM WebSphere TX / IBM TX Oracle adapter on any valid execution platform

DIAGNOSING THE PROBLEM
LASTERRORMSG() reports 'Failed to execute the SQL statement' and the database adapter log reports 'Unsupported datatype returned is being treated as text.'

RESOLVING THE PROBLEM
Redesign the Stored Procedure to NOT return a SYS_REFCURSOR datatype.
Stored Procedure in WTX 

Hi All,

Can anyone please share the example/steps/document link on how to call Stored Procedure in Input Card of a Map? The Stored Procedure will return multiple rows and columns and we need to map those rows in Output as well. Please enlighten if someone has worked on this?
SYS_REFCURSOR is not a valid datatype as a return from an Oracle stored procedure call using the WTX / ITX Oracle adapter.