Search code examples
c#oraclevisual-studioodp.netserver-explorer

Oracle Custom Class Wizard fails to generate custom c# class from Oracle User Defined Datatype

I am trying to generate custom .NET classes from an Oracle User-Defined Type from Visual Studio Server Explorer (Oracle Developer Tools for Visual Studio and Oracle Data Provider for .NET are installed).

I created a basic User Defined Type using server explorer as shown below:

Creating a user defined type using server explorer

After that I tried to generate custom class as shown below:

enter image description here

But when I am trying to complete the wizard:

enter image description here

in the the final step of the Wizard I am getting the following error:

Oracle Custom Class Wizard

Value cannot be null. Parameter name: type

enter image description here

I am not able to find why I am getting the error. Really appreciate any help.

Solution

  • Modify Oracle connection and use "Oracle Database (ODP.NET, Unmanaged Driver)"

    Data source = "Oracle Database"
    Data Provide = "ODP.NET, Unmanaged Driver" (Default was ODP.NET, managed Driver)

    using "ODP.NET, Unmanaged Driver" data provider this error will resolve (Its works for me in VS2012)