Passing User Defined Data type/ Oracle & .net

Hi,
Can any one help me with how to pass an user defined type in Oracle, which is used as an input parameter to a stored procedure, using .net.

First is it even possible if yes then how if some body has a link to an example that would be best.

I have seen example at msdn
"http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnadonet/html/advoracledataaccess.asp"

where they are passing values to the Oracle database using dynamic query string.

how would i pass the Oracle user-defined data type through .net to the stored procedure.

Hope to get the answer.

Amit

Answer this question

Passing User Defined Data type/ Oracle & .net

JD-SSan

I am guessing that it will work based on my experience with their components, but you should ask Oracle to be sure, since it's their product.

Thanks,
Sarah
Adrian Johnson

there some bugs in ODP.NET. since its developed in 2003. ORACLE didn't solve this problem. for example if connection string parameter have "user id" attribute its wrong, true type is "User Id". another problem, if you use unicode characters such as me , Turkish characters doesn't support or i can't solve it. Furthermore the regional and nls_language settings are true.

thanks,
SteveZ
its not depend on server version. if you setup ODP.NET, it update client version 10.2.0.2. db server version can be 9.
cos75

If you want to work with an actual type in your .NET code (as opposed to letting the object be created on the server through SQL, or retrieving the type in pieces as primitive types, like the example shows), you will not be able to do this using System.Data.OracleClient. However, from what I can tell, Oracle's ODP.NET does provide this functionality. From their website, it says this functionality is new in version 10.2.0.2 of the provider.

Thanks,
Sarah
Larry Tenny
my Oracle database version is 9 will the ODP.net 10.2.0.2 will work with that or I will have to use the ODP.net for version 9

if i have to use version 9 then i do not think i have that functionality available.

Amit
Passing User Defined Data type/ Oracle & .net

Answer this question