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

lottoman2000@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...

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/tec...ode/index.html

Greetings,
Moritz

Thanks for your reply.

It is really confusing. Oracle says that Oracle 10g R2 uses a PL/SQL
Wrapper to access the .NET stored procedure.
"The .NET stored procedure or function appears to the caller as a
PL/SQL stored procedure or function because a PL/SQL wrapper has been
generated for it. The user invokes a .NET stored procedure or function
through this PL/SQL wrapper. Oracle Deployment Wizard for .NET
determines the probable mappings between Oracle data types and .NET
data types, which the user can override. The mappings are handled
seamlessly by the PL/SQL wrapper."
http://download-east.oracle.com/docs...o.htm#BABCCJJD

Also according to Oracle, Oracle database lite does NOT support PL/SQL.
http://www.oracle.com/technology/pro...racle_diff.pdf

What do you think?

lottoman2000@gmail.com schrieb:
> Thanks for your reply.
>
> It is really confusing. Oracle says that Oracle 10g R2 uses a PL/SQL
> Wrapper to access the .NET stored procedure.
> "The .NET stored procedure or function appears to the caller as a
> PL/SQL stored procedure or function because a PL/SQL wrapper has been
> generated for it. The user invokes a .NET stored procedure or function
> through this PL/SQL wrapper. Oracle Deployment Wizard for .NET
> determines the probable mappings between Oracle data types and .NET
> data types, which the user can override. The mappings are handled
> seamlessly by the PL/SQL wrapper."
> http://download-east.oracle.com/docs...o.htm#BABCCJJD

Did not dive that deep into... It is on my to-test-list, but nothing done so far...

> Also according to Oracle, Oracle database lite does NOT support PL/SQL.
> http://www.oracle.com/technology/pro...racle_diff.pdf
> What do you think?

If you are just trying to get some knowledge regarding .NET SP then maybe take a
look at this link:
http://www.oracle.com/technology/tech/dotnet/index.html
I think I would go for Oracle XE and the Developer Tools for XE.
If you are trying to have .NET SP working on Oracle Lite it looks like you are
out of luck.

hth,
Moritz

Thanks man.

I am downloading Oracle lite 10gR2 now from Oracle. Then I will
download Oracle Database Extensions for .NET and see if will work. I
will let you know.

Cheers

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/tec...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...

Frank van Bortel schrieb:

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

*shiver*
Should have looked more into it, just skipped over the feature list..

"Moritz Klein" <mklein@students.uni-mainz.de> wrote in message
news:dmuk0v$vqv$1@news1.zdv.uni-mainz.de...
> Frank van Bortel schrieb:
>
>> The fact that it needs sys as sysdba connection makes any dba
>> shiver, by the way.
>
> *shiver*
> Should have looked more into it, just skipped over the feature list..


i'm suspicious of the reference i found to using a sysdba account to deploy
the .Net stored procedure... it's in a how-to article written by a
non-oracle person and there's no explanation why it would be necessary. it
looks like support for .Net stored procedures is just an extension of
external procedure calls which has been out there for many decades, to the
security concerns should be the same as they always have been when using
extproc.exe -- but i could not find any other info on deployment, so i'm
still wondering.

++ mcs

Mark C. Stock schrieb:

> i'm suspicious of the reference i found to using a sysdba account to deploy
> the .Net stored procedure... it's in a how-to article written by a
> non-oracle person and there's no explanation why it would be necessary. it
> looks like support for .Net stored procedures is just an extension of
> external procedure calls which has been out there for many decades, to the
> security concerns should be the same as they always have been when using
> extproc.exe -- but i could not find any other info on deployment, so i'm
> still wondering.

Same for me, every additional bit of information raises 5 other questions...
Time for some testing I would say.