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)
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
kanchana 120000A0VM147 Posts
Re: How to call a Stored Procedure with array param from C#2007-11-25T06:19:43ZThis is the accepted answer. This is the accepted answer.We do not support array parameters currently. It is on our to-do list, but has not been committed to any particular release.
ada4ko 270002EWHE1 Post
Arvind_Gupta 2700025SKH58 Posts