Skip Headers
Oracle® Database Extensions for .NET Developer's Guide
10g Release 2 (10.2)

Part Number B14306-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to next page
Next
PDF · Mobi · ePub

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