Topic
  • 4 replies
  • Latest Post - ‏2012-05-23T17:46:05Z by Arvind_Gupta
SystemAdmin
SystemAdmin
2826 Posts

Pinned topic How to call a Stored Procedure with array param from C#

‏2007-11-25T00:33:48Z |
Hello,
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[);
Any suggestions?

References
I have executed the following
CREATE TYPE S_LIST AS CHAR(12) ARRAY[100];
then created a SP accordingly
CREATE PROCEDURE PROCESS_LIST(IN p_SLIST S_LIST)
.....
Updated on 2012-05-23T17:46:05Z at 2012-05-23T17:46:05Z by Arvind_Gupta
  • kanchana
    kanchana
    147 Posts

    Re: How to call a Stored Procedure with array param from C#

    ‏2007-11-25T06:19:43Z  
    We do not support array parameters currently. It is on our to-do list, but has not been committed to any particular release.

    Kanchana
  • SystemAdmin
    SystemAdmin
    2826 Posts

    Re: How to call a Stored Procedure with array param from C#

    ‏2007-11-26T06:11:28Z  
    • kanchana
    • ‏2007-11-25T06:19:43Z
    We do not support array parameters currently. It is on our to-do list, but has not been committed to any particular release.

    Kanchana
    Well too bad...Thanks anyways
  • ada4ko
    ada4ko
    1 Post

    Re: How to call a Stored Procedure with array param from C#

    ‏2012-05-10T20:57:02Z  
    • kanchana
    • ‏2007-11-25T06:19:43Z
    We do not support array parameters currently. It is on our to-do list, but has not been committed to any particular release.

    Kanchana
    Any changes to this?
    I want to call stored procedure with array parm as output.
  • Arvind_Gupta
    Arvind_Gupta
    58 Posts

    Re: How to call a Stored Procedure with array param from C#

    ‏2012-05-23T17:46:05Z  
    • ada4ko
    • ‏2012-05-10T20:57:02Z
    Any changes to this?
    I want to call stored procedure with array parm as output.
    We do not support array parameters as output in stored procedure currently.