Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Extensions for .NET Developer's Guide
- 1 Introduction to Oracle Database Extensions for .NET
- 2
Installation and Configuration
- 2.1 System Requirements
- 2.2 Requirements for .NET Stored Procedures and Functions
- 2.3 Installation
- 2.4 Configuring Extproc Agent Using Windows Service
- 2.5 File Locations after Installation
- 2.6 Listener and Tnsnames Files
- 2.7 Migrating .NET Stored Procedures from Oracle Database 12c Release 1 (12.1) to Oracle Database 12c Release 2 (12.2)
- 2.8 Migrating .NET Stored Procedures from Oracle Database 11g Release 2 (11.2) to Oracle Database 12c Release 2 (12.2)
- 2.9
Mandatory Migration of .NET 1.x Stored Procedures to .NET 2.0 or Later
- 2.9.1 Determining if Code Changes are Needed
- 2.9.2 Migration Approaches
- 2.9.3 Addressing Code Incompatibilities Between ODP.NET for .NET 1.x and ODP.NET for .NET 2.0 or Later
- 2.9.4 Addressing Code Incompatibilities Between Oracle Database Extensions for .NET Versions 1.x and 2.0 or Later
- 2.9.5 Recompile and Redeploy .NET 1.x Stored Procedures Using ODP.NET for .NET 2.0 or Later
- 2.9.6 Configure .NET 1.x Stored Procedures Using ODP.NET for .NET 2.0 or Later
- 2.10 Oracle Database Extensions for .NET Registry Options
- 2.11 extproc.exe.config Configuration File
- 3
Development and Deployment with Visual Studio
- 3.1 Step 1: Develop the Stored Procedure or Function and Build it into an Assembly
- 3.2 Step 2: Run the Oracle Deployment Wizard for .NET
- 3.3 Step 3: Choose the Procedure or Function to Deploy and Security Level
- 3.4 Step 4: Determine the Appropriate Parameter Type Mappings
- 3.5 Step 5: Deploy the Procedure or Function
- 3.6 Step 6: Test the Procedure or Function
- 3.7 Step 7: Debug the Procedure or Function
- 4
Development and Deployment of a .NET Stored Function Demo
- 4.1 Overview of .NET Stored Function Demonstration
- 4.2 Step 1: Create the GetDeptNo Function and Build it into an Assembly
- 4.3 Step 2: Start the Oracle Deployment Wizard for .NET
- 4.4 Step 3: Choose the Function to Deploy
- 4.5 Step 4: Determine the Appropriate Parameter Type Mappings
- 4.6 Step 5: Deploy the Function to an Oracle Database
- 4.7 Step 6: Test the Function
- A Data Type Conversion
- B Troubleshooting Common Errors
- Glossary
- Index