2 Replies Latest reply on Dec 7, 2009 5:54 AM by 502182

    ODE.NET on 10g Database?!


      I found in the system requirements of ODE.NET that an Oracle Database 11g version is needed. My question is: Is it possible to install ODE.NET on an Oracle 10g Database?

      Thanks in advance!
        • 1. Re: ODE.NET on 10g Database?!
          Same question from me. I am using Visual Studio Tools for 11g which must work for 10g just fine and I have 10g server.

          I get this exception trying to run function from the tutorial:

          ------ Running Function HR.GETCOUNTRYNAME@SYSTEM.(Local Database) ------

          ORA-20100: System.TypeInitializationException
          The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.
          at Oracle.DataAccess.Client.OracleConnection..ctor()
          at MyStoredProcedure.Class1.GetCountryName(String CountryID)
          ORA-06512: at "SYS.DBMS_CLR", line 234
          ORA-06512: at "HR.GETCOUNTRYNAME", line 7
          ORA-06512: at line 1

          ---------------------- Done ----------------------

          As I understood, I must install server side 11g for this to work without any problems. But ODE.NET 11g requires 11g server. Any ideas how to solve it? It is written that .NET 11g Visual Studio Tools generated stuff should work with databases starting 9g.

          I have install Visual Studio 2005 and tried 10g Tools, but there is not "Oracle Project" template. Don't tell me that it is only available on 2003...

          Edited by: cybaslt@hotmail.com on 2009.11.29 08.10
          • 2. Re: ODE.NET on 10g Database?!
            You can use ODT of higher version to connect to an Oracle DB of lower version, in general. However, you can not deploy a .NET SP from ODT of higher version to Oracle DB of lower version. The reason for this lies in the fact that your .NET SP DLL references higher version of ODP.NET (Oracle.DataAccess.dll) than what is found in the database server machine.

            You may try the assembly redirection fix suggested in following message -

            Re: Error: System.TypeInitializationException