This content has been marked as final. Show 2 replies
Actually, there is an even better environment for .Net. Firstly, as always, there are OLEDB.Net and ODBC.Net providers, which give you the throughput that data access bridge-type providers generally provide. However, there is a new Oracle Data Provider for .Net (ODP.Net) which provides a native .Net-to-Oracle driver and does not use a data access bridge. Check out the details at http://otn.oracle.com/tech/windows/odpnet/content.html
Does the new Oracle Data Provider 18.104.22.168.1 support passing arrays to PL/SQL stored procedures whose procedures accept table arrays as the imput parameters? oo4o supported this functionality.
for example (in PL/SQL):
Create or Replace Package PackA as
TYPE varX IS TABLE OF VARCHAR2(10) INDEX BY BINARY INTEGER;
Procedure ProcA ( strName IN varX);
Create or Replace Package BODY PackA as
Procedure ProcA ( strName in varX) IS
-- Some processing
With oo4o the call would be set up like so (visual basic 6.0):
Dim NamePArray as OraParamArray
SET NamePArray = Oradatabase.Parameters("Name")
OraDatabase.ExecuteSQL ("begin Schema.PackA.ProcA(:Name);end;")
How do you make this call with the Oracle Data Provider (ODP) in .Net?
I've been unable to make this happen.