I'm working with someone proposing an Oracle Database running on a Linux platform but also wanting to run a .NET application on top with database embedded .NET stored procedures.
I am looking to establish what options are available and have some questions:
1) As far a I understand, the Oracle Developer Tools and Oracle Database Extensions for .NET give me an easy option for deploying stored procedures but will only work if the underlying database is running on Windows - is this correct?
2) Assuming the answer to 1) is yes, is there any alternative workaround? I have read about MONO but it appears this is not supported by Oracle?
3) Assuming the answer to 2) is no, what is the best option available? Converting the .NET code to Java?
.net stored procedures only run if the database is running on Windows. Far as I know there's no way around that. You'll need to port them to something else (like PL/SQL) to run them on a non-Windows database.