3 Replies Latest reply: Jul 15, 2011 12:51 PM by gdarling - oracle RSS

    Array-Binding to a List of Object

    user9082034
      Hello,
      I have read some articles about Array-Binding to get arrays of values with one statement in the database.
      (see http://dotnetslackers.com/articles/ado_net/BulkOperationsUsingOracleDataProviderForNETODPNET.aspx)
      In these examples the array contain simple values like numbers, varchars or dates. In .NET you are working most time with classes and you build lists of these classes.
      Example: Class Employee with the properties EmployeeId, Name, GivenName, Salary, ...
      I want to insert a List of Employee in the Database or use this list as parameter for a StoredProcedure (PL/SQL).
      Is this possible or what would be the recommended workarround?
      Thank you
      Peter