Is there a way from a C# application to call a stored procedure that takes an array input parameter?
The problem I am facing is that the DB2Parameter object only accepts objects types that come from
DB2Type enumeration, and it lacks an array type.
Note: that running the SP from a db2cmd works fine -> CALL PROCESS_LIST(ARRAY[);
I have executed the following
CREATE TYPE S_LIST AS CHAR(12) ARRAY;
then created a SP accordingly
CREATE PROCEDURE PROCESS_LIST(IN p_SLIST S_LIST)
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
4 replies Latest Post - 2012-05-23T17:46:05Z by Arvind_Gupta
Pinned topic How to call a Stored Procedure with array param from C#
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-23T17:46:05Z at 2012-05-23T17:46:05Z by Arvind_Gupta