How do we pass Arrays from .Net to Oracle stored procedure?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • aquils
    New Member
    • Nov 2009
    • 4
    #1

    How do we pass Arrays from .Net to Oracle stored procedure?

    Hi
    Can someone give me an idea on how do we pass Arrays from .Net to Oracle stored procedure?
    Thanks
    Tags: None
    • Frinavale
      Recognized Expert Expert
      • Oct 2006
      • 9749
      #2
      Umm...

      Does the Oracle Stored Procedure expect that an array be passed to it?

      I'm not great with Database stuff, and have only just had introductions to Oracle...but I've never heard of passing an array to a stored procedure.

      I don't even think that Oracle has arrays.
      Even if Oracle had arrays, they would be different from .NET "Arrays" and you would have to use something to translate the .NET array into an Oracle array.

      Are you sure there are even arrays in Oracle????

      Could you please provide me with more details on what exactly you are trying to do?

      -Frinny

        Comment

        • artov
          New Member
          • Jul 2008
          • 40
          #3
          It depends how you like to use the array. Small search with google gave this page: http://www.oracle.com/technology/sam...ind/index.html where the procedure is called once for each array element (the procedure inserts the values to a table).

          I do not know how the array call is implemented, but it might be, that the array is moved as a whole to the server and the server side calls the procedure for each array element. This way, the execution will be faster since there will be less communication between the client and the server.

            Comment

            Previous template Next
            Working...