Using .NET Stored Procedures in Oracle 10gR2

Lucas Jellema 1
0 0
Read Time:1 Minute, 18 Second

From the OTN Series on “Mastering .NET Application Development with Oracle”, this installment on taking advantage of .NET stored procedures in your applications. See Using .NET Stored Procedures in Oracle

PL/SQL stored procedures and functions run in the same process as the Oracle Database and are stored inside of Oracle. A .NET stored procedure, on the other hand, runs in an external process and the .NET code is compiled into a “.NET assembly,” which is a dynamic link library (DLL) file stored in the file system (usually on the same machine as the database). The .NET assembly is loaded into and executed inside of a “CLR host” external process named extproc.exe, which is spawned by the Windows service named ClrAgnt. When a .NET stored procedure call is made, Oracle communicates with this external process, passing in the arguments and retrieving the results. This communication is handled by the Oracle multithreaded agent architecture. To the end user, a .NET stored procedure call appears to be no different than any other type of stored procedure call. In fact, a .NET stored procedure can be called from any environment where you could call a PL/SQL or Java stored procedure.

If you are using Oracle Database 10g Express Edition, .NET stored procedures are automatically installed and configured—no additional configuration is required. In the Standard and Enterprise Editions, however, .NET stored procedures are not installed and configured by default. Note: you need Oracle Database 10.2 or later for the Windows platform. (Note: .NET stored procedures are not supported on any other platform!)

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

One thought on “Using .NET Stored Procedures in Oracle 10gR2

  1. I´m having the following problem using Oracle .Net procedues.

    I´ve made a function that return an accent a (á) but when I call it, returns another value.

    Public Shared Function x1() As String
    Return “á”
    End Function

    Public Shared Function x2() As String
    Dim oConDB As New DoConexionOracle(Constants.STRCON)
    Return oConDB.ObtenerEscalarFromSQL(“select ‘á’ FROM DUAL”)
    End Function

    SELECT x1() FROM DUAL
    á

    SELECT x2() FROM DUAL
    á

    Any idea?
    TIA,
    Christian

Comments are closed.

Next Post

ODTUG 2006 in Washington, DC - Abstracts Due 12 December

The next edition of the yearly reunion of the best (and nicest) Oracle Developers in the world is going to be held from June 17th to June 21st, in Washington DC – the closest to home they have ever been. ODTUG (Oracle Development Tools User Group) conferences are always interesting […]
%d bloggers like this: