This discussion is archived
2 Replies Latest reply: Dec 6, 2009 9:54 PM by 502182 RSS

ODE.NET 11.1.0.7.20 on 10g Database?!

669018 Newbie
Currently Being Moderated
Hi,

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

Thanks in advance!
  • 1. Re: ODE.NET 11.1.0.7.20 on 10g Database?!
    737694 Newbie
    Currently Being Moderated
    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 11.1.0.7.20 on 10g Database?!
    502182 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points