Re: .NET Stored procedures and Oracle 10g lite R2

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 04 Dec 2005 10:31:48 +0100
Message-ID: <dmucf0$vie$1@news6.zwoll1.ov.home.nl>

Moritz Klein wrote:
> Frank van Bortel schrieb:
>
>

>>As may have become clear, .Net code cannot be executed
>>by Oracle, and thus not stored as Stored Procedure.

>
>
> Which is wrong, please look up the features of Oracle 10gR2 instead of posting
> wrong answer please.
> Link to get you into it: http://www.oracle.com/technology/tech/dotnet/ode/index.html
>
> Greetings,
> Moritz

Still... it's not the .net code that's executed... Things have become easier with the extension (which I was unaware of; thanks for that), but the bottom line is that it's a PL/SQL wrapped procedure. The wizard screen informs you about it: This wizard will ... generate stub stored procedures. The actual code is now a function within the HR schema. Boils down to: not needing to know how to program in PL/SQL.

The fact that it needs sys as sysdba connection makes any dba shiver, by the way.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Sun Dec 04 2005 - 03:31:48 CST