Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: .NET Stored procedures and Oracle 10g lite R2

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

From: <lottoman2000_at_gmail.com>
Date: 3 Dec 2005 12:28:55 -0800
Message-ID: <1133641735.429635.80970@g49g2000cwa.googlegroups.com>


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/cd/B19306_01/win.102/b14306/intro.htm#BABCCJJD

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

What do you think? Received on Sat Dec 03 2005 - 14:28:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US