Oracle Database Extensions for  .NET

Installation Guide and Release Notes

For white papers, walkthroughs, demos and more information, visit the Oracle Database Extensions for .NET Tech Center at http://www.oracle.com/technology/tech/dotnet/ode/index.html

Release 11.2.0.1.0 Production

February 2010

Copyright (c) Oracle Corporation 2010

This file contains important information about Oracle Database Extensions for .NET which is a database option for Oracle Database 11g Release 2 on Windows.  The following topics are covered.

• Support and Product Feedback
• Documentation
  
• Information and Known Issues
  

Support and Product Feedback

Oracle is very interested to hear your comments related to this feature, including feature requests and bug reports. Please visit the Oracle Technology Network (OTN)  community forums to tell us what you think!

http://forums.oracle.com/forums/forum.jspa?forumID=254 (Registration with OTN required)
 

Documentation

Visual Studio .NET Help Integration

The Oracle Database Extensions for .NET Developers Guide has been integrated with Visual Studio .NET help and is included as part of the Oracle Developer Tools for Visual Studio .NET version 10.2 or later. 

Online Documentation

The documentation may also be read online at the Oracle Technology Network (OTN).

Information and Known Issues

While debugging .NET Procedure/Function, utilizing the  "Run" Option on Server Explorer causes hang

When attaching to the extproc.exe and debugging a .NET stored procedure (see documentation), avoid using the "Run" context menu option for the procedure or function in Oracle Explorer (part of the Oracle Developer Tools for Visual Studio .NET). This will result in a hang of Visual Studio and a loss of work. Alternately, either call the procedure or function from the Query Window via SQL, or  open a new Visual Studio .NET instance and use the "Run" menu option from there.

Manually Starting Extproc Agent

Rather than relying on the provided service, the multi-threaded Extproc agent (extproc.exe)  can also be started and shutdown using the agtctl.exe utility using the syntax

agtctl startup extproc CLRExtProc
    
agtctl shutdown immediate CLRExtProc

Individual agtctl.exe commands will then be needed to be used to set max_dispatchers, max_threads and max_sessions parameters. Please refer to the Oracle Database Heterogeneous Connectivity Administrator's Guide for further information.

Use of DBLink is not supported with context connection

DB links may not be used with the context connection (context connection is the connection inherited from the caller of the stored procedure or function).

Re-deploying assemblies referenced by a .NET stored procedure or function

The multi-threaded extproc agent (extproc.exe) needs to be stopped to re-deploy assemblies referenced by a .NET stored procedure or function. This is typically achieved by stopping and restarting the Oracle<HomeName>ClrAgnt service.

XML Save Functionality

XML Save functionality is not supported in this release.