Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Passwords in Code Examples
• Conventions

What's New in Oracle Database Extensions for .NET

• New Features in Oracle Database Extensions for .NET Release 11.2.0.1.2
• New Features in Oracle Database Extensions for .NET Release 11.1.0.6.20

1 Introduction to Oracle Database Extensions for .NET

• Oracle Database Extensions for .NET Overview
• Oracle Database Extensions for .NET Architecture
  • Oracle CLR Host
  • External Processes
    • Dedicated Agent Architecture
    • Multithreaded Agent Architecture
    • Listener and Tnsnames Files
• Oracle Data Provider for .NET
• Oracle Developer Tools for Visual Studio
• Oracle Deployment Wizard for .NET

2 Installation and Configuration

• System Requirements
• Requirements for .NET Stored Procedures and Functions
• File Locations after Installation
• Installation and First Use
• Configuring Extproc Agent Using Windows Service
  • OraClrAgnt Service Parameters
  • Tuning OraClrAgnt for Performance
• Migrating .NET Stored Procedures from Oracle Database 10.2 to Oracle Database 11.2
• Mandatory Migration of .NET 1.x Stored Procedures to .NET 2.0
  • Determining if Code Changes are Needed
  • Migration Approaches
  • Addressing Code Incompatibilities Between ODP.NET for .NET 1.x and ODP.NET for .NET 2.0
  • Addressing Code Incompatibilities Between Oracle Database Extensions for .NET Versions 1.x and 2.0
  • Recompile and Redeploy .NET 1.x Stored Procedures Using ODP.NET for .NET 2.0
  • Configure .NET 1.x Stored Procedures Using ODP.NET for .NET 2.0
• Oracle Database Extensions for .NET Registry Options
  • Unloading .NET Assemblies for Easy Redeployment
  • Backward Compatibility for Nullable ODP.NET Connected Types
  • Selecting a .NET Run Time Version
  • Debug Tracing
    • TraceOption
    • TraceFileName
    • TraceLevel
• Unhandled Exceptions
  • extproc.exe Config File

3 Development and Deployment with Visual Studio

• Step 1: Develop the Stored Procedure or Function and Build it into an Assembly
• Step 2: Run the Oracle Deployment Wizard for .NET
• Step 3: Choose the Procedure or Function to Deploy and Security Level
• Step 4: Determine the Appropriate Parameter Type Mappings
• Step 5: Deploy the Procedure or Function
• Step 6: Test the Procedure or Function
• Step 7: Debug the Procedure or Function

4 Development and Deployment of a .NET Stored Function Demo

• Overview of .NET Stored Function Demonstration
• Step 1: Create the GetDeptNo Function and Build it into an Assembly
• Step 2: Start the Oracle Deployment Wizard for .NET
• Step 3: Choose the Function to Deploy
• Step 4: Determine the Appropriate Parameter Type Mappings
• Step 5: Deploy the Function to an Oracle Database
• Step 6: Test the Function
  • Invoking from Oracle Developer Tools for Visual Studio
  • Invoking from ODP.NET client
  • Invoking from SQL*Plus

A Data Type Conversion

B Troubleshooting Common Errors

Glossary

Index