BW JDBC call procedure activity is unable to call a stored procedure that returns an array of objects
Article ID: KB0091420
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
For now, it's NOT possible to pass an array as a parameter from a JDBC Call Procedure activity.
We already filed an enhancement request (1-UVQUP) to DataDirect to support ARRAY data type but not sure how soon they will be able to do it.
So for now, you will have to use Java Code activity where you can use Oracle specific API to handle ARRAY as in/out/inout parameter
of a stored procedure. I believe Oracle user’s guide or programmer’s guide should have some sample codes working with ARRAY
as in/out/inout parameter of a stored procedure.
NOTE:- The situation changes with BW 5.6 where we support a number of Oracle dataypes like table, object, collection , clob, blob, PL/SQL integer etc. Please refer release notes for details
For now, it's NOT possible to pass an array as a parameter from a JDBC Call Procedure activity.
We already filed an enhancement request (1-UVQUP) to DataDirect to support ARRAY data type but not sure how soon they will be able to do it.
So for now, you will have to use Java Code activity where you can use Oracle specific API to handle ARRAY as in/out/inout parameter
of a stored procedure. I believe Oracle user’s guide or programmer’s guide should have some sample codes working with ARRAY
as in/out/inout parameter of a stored procedure.
NOTE:- The situation changes with BW 5.6 where we support a number of Oracle dataypes like table, object, collection , clob, blob, PL/SQL integer etc. Please refer release notes for details
Issue/Introduction
BW JDBC call procedure activity is unable to call a stored procedure that returns an array of objects
Feedback
Yes
No
Powered by
