Hi, I'm working on .NET Stored Procedure.
I use VS 2008. with ODT 11.1.06.20 I deployed it to local 11g DB it worked fine.
I need this on XE wich is a target platform for this solution, unfortunately when I deployed it (successfully) from VS to remote DB and tried to test it I got error:
ERROR at line 1:
ORA-20100: Invalid number of parameters.
ORA-06512: at "SYS.DBMS_CLR", line 234
ORA-06512: at "MYPACKAGE.MYFUNCTION", line 6
It's parameter-less function returning Varchar2 with security type UNSAFE.
It seems like differences in package DBMS_CLR between those two releases.
You will have to use Oracle Developer Tools for Visual Studio (ODT) for XE. However that does not support developing .NET stored procedures other than from VS2003. Not sure if that is an option for you.
It's scary too, Is it the only version that works with XE?
First line of Known issues is :
"Visual Studio .NET 2005/2002 not supported in this release
This release will not work properly with Visual Studio 2005 nor with Visual Studio .NET 2002. Please note: support or Visual Studio 2005 will be included in an upcoming release."
Has nothing been changed in those last 3 years?
It looks like now it requires XE installation. I have 11g installed on my laptop and I'd prefer not to remove it. Is there any possibility to keep it and work with this version of client or should You into "virtualization" to proceed with it?