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
- System Requirements
- Requirements for .NET Stored Procedures and Functions
- Installation
- Configuring Extproc Agent Using Windows Service
- File Locations after Installation
- Listener and Tnsnames Files
- Migrating .NET Stored Procedures from Oracle Database 12c Release 1 (12.1) or later
- Migrating .NET Stored Procedures from Oracle Database 11g Release 2 (11.2)
-
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
- extproc.exe.config Configuration 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
- A Data Type Conversion
- B Troubleshooting Common Errors
- Glossary
- Index