This content has been marked as final. Show 2 replies
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) ------
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.
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: email@example.com on 2009.11.29 08.10
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