I am trying to find out if it is possible to pass an array object (C#) to an Oracle function using ODP.NET for use in SELECT statement.
This article seems to say that it isn't possible for SELECT statements.
ODP.NET: Put Your Arrays in a Bind
Basically, I need to pass the array of values so they can be used for a "WHERE ___ IN < >" clause.
Example:
c# string array = "Adam", "Bob"
Oracle function:
SELECT * FROM Employees WHERE Name in <array>
I understand I can do this using nested tables, but it seems I have to pass a string value as a parameter, not an array object.