Go to main content
1/11
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
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 Deployment Wizard for .NET
Oracle Data Provider for .NET
Oracle Developer Tools for Visual Studio .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
3
Development and Deployment with Visual Studio .NET
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 .NET
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.