Skip Headers
Oracle® Database Extensions for .NET Developer's Guide
11
g
Release 2 (11.2) for Microsoft Windows
Part Number E17724-01
Home
Book List
Index
Master Index
Contact Us
Next
PDF
·
Mobi
·
ePub
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
Scripting on this page enhances content navigation, but does not change the content in any way.