I know that this is my third post for the day, but when I saw this I was so excited. Yes, there are managed stored procedures in Oracle as well. Just a quick note, the new Microsoft SQL Server 2005 supports managed stored procedures, which are procedures written in one of the managed .NET languages. The benefit? Well, you don't have to know T-SQL in this case, in order to have access to your data. It is obvious that Oracle hasn't waited too long and now not only they support Microsoft .NET Framework 2.0, but have implemented the same type of SPs in their database server. Impressive!
I found one very good article about this feature in Oracle 10g. Check it out it is really great (click here)! What I find astonishing with it, is the Deployment wizard - once you have created your stored procedure in a managed .NET programming language, you have easy deployment through a nice-and-tidy wizard. Well, another story is that you can debug your Oracle .NET stored procedures through Microsoft Visual Studio .NET 2003 - yeah, no kiddin'! :) Just read this article...
No comments:
Post a Comment