1/12
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Passwords in Code Examples
Conventions
Changes in This Release for Oracle Database Extensions for .NET Developer's Guide
Changes in Oracle Database 12
c
Release 1 (12.1)
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
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
Installation
Installation and First Use
Oracle CLR Services and the Oracle Home User Account
Using the OraClrCtl Utility to Create and Run OraClrAgent Services
Configuring Extproc Agent Using Windows Service
OraClrAgnt Service Parameters
Tuning OraClrAgnt for Performance
File Locations after Installation
Listener and Tnsnames Files
Migrating .NET Stored Procedures from Oracle Database 11.2 to Oracle Database 12.1
Mandatory Migration of .NET 1.x Stored Procedures to .NET 2.0 or Later
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 or Later
Addressing Code Incompatibilities Between Oracle Database Extensions for .NET Versions 1.x and 2.0 or Later
Recompile and Redeploy .NET 1.x Stored Procedures Using ODP.NET for .NET 2.0 or Later
Configure .NET 1.x Stored Procedures Using ODP.NET for .NET 2.0 or Later
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
Scripting on this page enhances content navigation, but does not change the content in any way.