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