ricksmt ricksmt - 1 month ago 12
C# Question

Create input table parameter for calling Oracle stored procedure in C#

I'm trying to use an Oracle stored procedure that takes

TABLE of NUMBER
for two of its inputs. I'm calling it from C# and I'd like to use
System.Data.OracleClient
as opposed to ODP.NET because that's approach my company is currently taking, so please avoid answers utilizing ODP.NET. I haven't been able to create acceptable input parameters. What should I do?

Answer

It's been a few years since I've tried anything like this, but historically, passing esoteric types (arrays, user-defined types, tables) to .NET managed data providers has been poorly supported at best. I doubt System.Data.OracleClient supports this. You'll probably have better luck with ODP.NET.

Worth noting: http://msdn.microsoft.com/en-us/library/77d8yct7.aspx

Comments