New problems with .NET stored procedures and Oracle XE
45675Sep 2 2006 — edited Sep 6 2006The other day, I tried unsuccessfully to get the example HR.GetCountryName stored procedure to work that is featured in an OTN article. I gave up, uninstalled everything and started over. I couldn't get passed the 'unable to connect to external process' error.
Now, after trying again from scratch, I get the following exception when I run:
ORA-20100: System.InvalidOperationException
This operation is not supported in a non Oracle-CLR thread
at Oracle.DataAccess.Client.OracleConnection.Open()
at MyStoredProcedure.Class1.GetCountryName(String CountryID)
ORA-06512: at "SYS.DBMS_CLR", line 234
ORA-06512: at "SYS.GETCOUNTRYNAME", line 7
ORA-06512: at line 1
I've seen posts about this problem too and I get around it by killing the extproc process and starting the service again, only to get the same original error about being unable to connect to external process.
I can only assume from the recent posts on this forum, almost all of them leaving the problems raised unsolved, that most developers trying out .NET stored procs are simply giving up in frustration. Is this software just too immature? There's just not alot of documentation out there and not alot of forum support (though I certainly do help the assistance I have received in this forum).
I'm using VS 2005, Oracle XE, and the latest ODP download. So, I guess I'm looking for other suggestions to the CLR problems I'm receiving, and no one has any, I'm interested in hearing about whether others are as close as I am to writing this technology off for another 6-12 months.
Mike