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

lottoman2000_at_gmail.com wrote:
> Hello Team..
>
> Does Oracle lite 10g R2 supports .NET stored procedures? Oracle
> document only show that they support Java SP but they didn't mention
> that it does not support .NET SP.
>
> Please let me know
>
> Thanks
>

What is a .Net SP? Oracle stores program code internally. The non-lite versions have PL/SQL functions, procedures and packages which contain code, executed by the database. Thus, it must be code, "comprehensible" by Oracle; PL/SQL or Java.

Oracle Lite is a small footprint, all Java database. If it supports PL/SQL, it can store PL/SQL procedures, packages and functions. I doubt it - probably Java only.

As may have become clear, .Net code cannot be executed by Oracle, and thus not stored as Stored Procedure. Of course you can store source code as text (In a Character Large Object, or CLOB), or as compiled code (in a Binary LOB) in the database, but it cannot be executed by Oracle.

-- 
Regards,
Frank van Bortel

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