none
Passing Varray of object to Procedure from .net RRS feed

  • Question

  •  

    Can any one help on this issue;

    I have some procedures which accepts Array of objects in parameter ,

    I want to assign that parameter value from C#.

     

    Is it possible thru any .net component

    I can use

    Oracle.DataAccess

    or

    System.Data.OracleClient

    Wednesday, October 15, 2008 3:42 PM

All replies

  • Do you need to pass array of values to stored procedure? If yes and Oracle support XML I would suggest to create XML string that will contain values and then pass it as string parameter to stored procedure. Then use prepared XML inside of SP

    Wednesday, October 15, 2008 8:51 PM
    Moderator
  • Passing value thru XML or varchar2 is possible but for that I need to change logic in Procedure,

    Which is not permissible as i am working on migration from ASP to asp.net

     

    so as to keep all database objects as it is I need to send array of objects.

     

    Thursday, October 16, 2008 4:49 AM
  • I do not think array parameters are supported on stored procedure level. You would need to make some tradeoffs.

     

    Thursday, October 16, 2008 5:58 PM
    Moderator