Developer's Guide Oracle Providers For ASP
Oracle Providers for ASP.NETDeveloper's Guide19c for Microsoft WindowsF19461-01June 2019
Oracle Providers for ASP.NET Developer's Guide, 19c for Microsoft WindowsF19461-01Copyright 2007, 2019, Oracle and/or its affiliates. All rights reserved.Primary Author: Maitreyee ChalihaContributing Authors: Alex Keh, Janis Greenberg, Sumit Jeloka, Sheela Vasudevan, Kimnari Akiyama, NeerajGupta, Sinclair Hsu, Ashish Shah, Arun SinghThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in your li‐cense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engi‐neering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibit‐ed.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-spe‐cific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the pro‐grams, including any operating system, integrated software, any programs installed on the hardware, and/ordocumentation, shall be subject to license terms and license restrictions applicable to the programs. No otherrights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devi‐ces. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly dis‐claim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content, prod‐ucts, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPrefaceAudiencexiiDocumentation AccessibilityxiiRelated DocumentsxiiPasswords in Code ExamplesxiiiConventionsxiiiChanges in This Release for Oracle Providers for ASP.NET Develo‐per's Guide1Changes in Oracle Providers for ASP.NET in ODAC 12c Release 4xivChanges in Oracle Providers for ASP.NET Release 11.2.0.2xivChanges in Oracle Providers for ASP.NET Release 11.2.0.1.2xvIntroduction to Oracle Providers for ASP.NET1.4Connecting to Oracle Database Cloud Service1-11.1Overview of Oracle Providers for ASP.NET1-11.2Oracle Providers for ASP.NET Assembly1-41.3System Requirements1-51.5Oracle Providers for ASP.NET Installation1-51.5.11-81.5.1.1Database Privileges for Setup1-81.5.1.2Configuring All Oracle Providers for ASP.NET1-91.5.1.3Configuring Oracle Providers for ASP.NET Individually1-91.5.1.4General Setup Information1.5.21.6Database Server SetupASP.NET Client SetupUpgrading Oracle Providers for ASP.NET1.6.1Coexistence of Multiple Oracle Providers for ASP.NET Versions1-101-101-111-121.7File Locations After Installation1-121.8Oracle Providers for ASP.NET Object References1-131.8.1Tables1-131.8.2Roles1-14iii
1.8.31-151.8.3.1OracleMembershipProvider Views1-151.8.3.2OracleRoleProvider Views1-151.8.3.3OracleProfileProvider Views1-161.8.3.4OraclePersonalizationProvider Views1-161.8.3.5OracleSessionStateStore Views1-161.8.4Stored Procedures1-161.8.4.1OracleMembershipProvider Stored Procedures1-171.8.4.2OracleRoleProvider Stored Procedures1-181.8.4.3OracleProfileProvider Stored Procedures1-191.8.4.4OraclePersonalizationProvider Stored Procedures1-201.8.4.5OracleWebEventProvider Stored Procedures1-211.8.4.6OracleSiteMapProvider Stored Procedures1-211.8.4.7OracleSessionStateStore Provider Stored hipProvider2.1OracleMembershipProvider Class2-12.1.1OracleMembershipProvider Members2-32.1.2OracleMembershipProvider 62.1.3OracleMembershipProvider Static Methods2-72.1.4OracleMembershipProvider Public 5OracleMembershipProvider Public v
1.5.12GetUser(Object, bool)2-312.1.5.13GetUser(string, 2-382.1.63OracleMembershipProvider Public Events2-39OracleRoleProvider3.1OracleRoleProvider Class3-13.1.1OracleRoleProvider Members3-33.1.2OracleRoleProvider OracleRoleProvider Static Methods3-53.1.4OracleRoleProvider Public ndTimeout3-73.1.5OracleRoleProvider Public 63.1.5.11RoleExists3-17v
4OracleSiteMapProvider4.1OracleSiteMapProvider Class4.1.1OracleSiteMapProvider Members4-34.1.2OracleSiteMapProvider Constructors4-54.1.2.14-5OracleSiteMapProvider Static Methods4-64.1.4OracleSiteMapProvider Public ndTimeout4-8OracleSiteMapProvider Public cleSessionStateStore Class5-15.1.1OracleSessionStateStore Members5-25.1.2OracleSessionStateStore Store()OracleSessionStateStore Public 554-1CommandTimeoutOracleSessionStateStore Public rovider Class6.1.1OracleProfileProvider Members6-16-3vi
6.1.2OracleProfileProvider Constructors6.1.2.1OracleProfileProvider Static Methods6-66.1.4OracleProfileProvider Public ndTimeout6-7OracleProfileProvider Public OracleWebEventProvider7.1OracleWebEventProvider Class7-17.1.1OracleWebEventProvider Members7-37.1.2OracleWebEventProvider .1.3OracleWebEventProvider Static Methods7-67.1.4OracleWebEventProvider Public er Public tionProvider Class8-18.1.1OraclePersonalizationProvider Members8-38.1.2OraclePersonalizationProvider r()8-5vii
8.1.3OraclePersonalizationProvider Static Methods8-58.1.4OraclePersonalizationProvider Public ndTimeout8-88.1.59OraclePersonalizationProvider Public .5.5ResetUserState8-14OracleCacheDependency Provider9.1OracleCacheDependency Class9-19.1.1OracleCacheDependency Members9-29.1.2OracleCacheDependency Command)9-39.1.3OracleCacheDependency Properties9-49.1.4OracleCacheDependency Methods9-49.1.4.1GetUniqueID9-5Indexviii
List of Tables1-1Oracle Providers for ASP.NET Namespaces and Providers1-41-2Install Scripts1-91-3Provider Tables1-131-4Roles and StateStore1-161-10ora aspnet Mem BasicAccess Role1-171-11ora aspnet Mem ReportAccess Role1-171-12ora aspnet Mem FullAccess Role1-171-13ora aspnet Roles BasicAccess Role1-181-14ora aspnet Roles ReportAccess Role1-181-15ora aspnet Roles FullAccess Role1-191-16ora aspnet Prof BasicAccess Role1-191-17ora aspnet Prof ReportAccess Role1-191-18ora aspnet Prof FullAccess Role1-201-19ora aspnet Pers BasicAccess Role1-201-20ora aspnet Pers ReportAccess Role1-201-21ora aspnet Pers FullAccess Role1-201-22ora aspnet Wevnt FullAccess Role1-211-23ora aspnet Smap FullAccess Role1-211-24ora aspnet Sessn FullAccess Role1-212-1OracleMembershipProvider Constructor2-32-2OracleMembershipProvider Static Methods2-32-3OracleMembershipProvider Public Properties2-32-4OracleMembershipProvider Public Methods2-42-5OracleMembershipProvider Public Event2-52-6OracleMembershipProvider Static Methods2-72-7OracleMembershipProvider Public Properties2-72-8OracleMembershipProvider Public Methods2-182-9MembershipCreateStatus Enumeration Values2-232-10OracleMembershipProvider Public Events2-393-1OracleRoleProvider Constructor3-3ix
3-2OracleRoleProvider Static Methods3-33-3OracleRoleProvider Public Properties3-33-4OracleRoleProvider Public Methods3-43-5OracleRoleProvider Static Methods3-53-6OracleRoleProvider Public Properties3-63-7OracleRoleProvider Public Methods3-84-1OracleSiteMapProvider Constructor4-34-2OracleSiteMapProvider Static Methods4-34-3OracleSiteMapProvider Public Properties4-34-4OracleSiteMapProvider Public Methods4-44-5OracleSiteMapProvider Static Methods4-64-6OracleSiteMapProvider Public Properties4-64-7OracleSiteMapProvider Public Methods4-85-1OracleSessionStateStore Constructor5-35-2OracleSessionStateStore Public Properties5-35-3OracleSessionStateStore Public Methods5-35-4OracleSessionStateStore Public Properties5-55-5OracleSessionStateStore Public Methods5-66-1OracleProfileProvider Constructor6-36-2OracleProfileProvider Static Methods6-36-3OracleProfileProvider Public Properties6-46-4OracleProfileProvider Public Methods6-46-5OracleProfileProvider Static Methods6-66-6OracleProfileProvider Public Properties6-66-7OracleProfileProvider Public Methods6-87-1OracleWebEventProvider Constructor7-47-2OracleWebEventProvider Static Methods7-47-3OracleWebEventProvider Public Properties7-47-4OracleWebEventProvider Public Methods7-47-5OracleWebEventProvider Static Methods7-67-6OracleWebEventProvider Public Properties7-67-7OracleWebEventProvider Public Methods7-78-1OraclePersonalizationProvider Constructor8-38-2OraclePersonalizationProvider Static Methods8-38-3OraclePersonalizationProvider Public Properties8-38-4OraclePersonalizationProvider Public Methods8-48-5OraclePersonalizationProvider Static Methods8-6x
8-6OraclePersonalizationProvider Public Properties8-68-7OraclePersonalizationProvider Public Methods8-89-1OracleCacheDependency Constructor9-29-2OracleCacheDependency Properties9-29-3OracleCacheDependency Methods9-39-4OracleCacheDependency Properties9-49-5OracleCacheDependency Methods9-5xi
PrefacePrefaceThis document is your primary source of introductory, installation, postinstallation con‐figuration, and usage information for Oracle Providers for ASP.NET.This Preface contains these sections: Audience Documentation Accessibility Related Documents Passwords in Code Examples ConventionsAudienceOracle Providers for ASP.NET Developer's Guide is intended for programmers whoare developing applications using ASP.NET providers to store application state in Ora‐cle databases.To use this guide, you must be familiar with Microsoft .NET Framework classes,ASP.NET, and ADO.NET, and have a working knowledge of application programmingusing Microsoft C#, Visual Basic .NET, or another .NET language.Although the examples in the documentation and the samples in the sample directoryare written in C#, developers can use these examples as models for writing code inother .NET languages.Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibili‐ty Program website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic supportthrough My Oracle Support. For information, visit http://www.oracle.com/pls/topic/look‐up?ctx acc&id info or visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trs ifyou are hearing impaired.Related DocumentsFor more information, see these Oracle resources: Oracle Database Installation Guide for Windowsxii
Preface Oracle Database Release Notes for Windows Oracle Database Platform Guide for Windows Oracle Database New Features Oracle Database Concepts Oracle Database Reference Oracle Data Provider for .NET Developer's Guide Oracle Developer Tools for Visual Studio .NET HelpPasswords in Code ExamplesFor simplicity in demonstrating this product, code examples do not perform the pass‐word management techniques that a deployed system normally uses. In a productionenvironment, follow the Oracle Database password management guidelines, and disa‐ble any sample accounts. See Oracle Database Security Guide for password manage‐ment guidelines and other security recommendations.ConventionsThe following text conventions are used in this guide:ConventionMeaningboldfaceBoldface type indicates graphical user interface elements associatedwith an action, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables forwhich you supply particular values.monospaceMonospace type indicates commands within a paragraph, URLs, codein examples, text that appears on the screen, or text that you enter.xiii
Changes in This Release for Oracle Providers for ASP.NET Developer's GuideChanges in This Release for Oracle Pro‐viders for ASP.NET Developer's GuideThis preface contains: Changes in Oracle Providers for ASP.NET in ODAC 12c Release 4 Changes in Oracle Providers for ASP.NET Release 11.2.0.2 Changes in Oracle Providers for ASP.NET Release 11.2.0.1.2Changes in Oracle Providers for ASP.NET in ODAC 12c Re‐lease 4The following are changes in Oracle Providers for ASP.NET for ODAC 12c Release 4.New FeaturesThe following features are new in this release: NuGetOracle Providers for ASP.NET are available in a NuGet package. This capabilitysimplifies distributing these providers to developers and end users. Windows InstallerOracle Providers for ASP.NET are now available as part of an ODAC MicrosoftWindows Installer (MSI) package. ODP.NET, Managed Driver SupportOracle Providers for ASP.NET for .NET Framework 4 and higher depend onODP.NET, Managed Driver (Oracle.ManagedDataAccess.dll), rather thanODP.NET, Unmanaged Driver (Oracle.DataAccess.dll) as in previous releases.The providers' DLL version is 4.121.2.1, which distinguishes it from its predeces‐sor version 4.121.2.0, which in ODAC 12c Release 3 depended on unmanagedODP.NET. In addition, Oracle Providers for ASP.NET for .NET Framework 4 andhigher is now a platform independent assembly, enabling platform-independentapplications to simply use the same .NET assembly, regardless of the platform.Oracle Providers for ASP.NET for .NET Framework 2.0 is platform dependent anddepends on ODP.NET, Unmanaged Driver. Its version number remains the sameas 2.121.2.0.Changes in Oracle Providers for ASP.NET Release 11.2.0.2The following are changes in Oracle Providers for ASP.NET for Release 11.2.0.2.xiv
Changes in This Release for Oracle Providers for ASP.NET Developer's GuideNew FeaturesThe following feature is new in this release: 64-bit Oracle Providers for ASP.NET XCopy for Windows x64Now available for Windows x64 systems, Oracle Providers for ASP.NET XCopyprovides system administrators with a smaller client install size than the standardclient, and is easier to configure. XCopy simplifies embedding the ASP.NET pro‐viders in customized deployment packages.See Also:XCopy under "Oracle Providers for ASP.NET Installation."Changes in Oracle Providers for ASP.NET Release11.2.0.1.2The following are changes in Oracle Providers for ASP.NET for Release 11.2.0.1.2.New FeaturesThe following feature is new in this release: ASP.NET 4 SupportOracle Providers for ASP.NET 4 supports ASP.NET 4.xv
1Introduction to Oracle Providers forASP.NETOracle Providers for ASP.NET integrates directly with Microsoft ASP.NET controls andservices to provide state management capabilities for web sites.The following topics introduce Oracle Providers for ASP.NET. Overview of Oracle Providers for ASP.NET Oracle Providers for ASP.NET Assembly System Requirements Connecting to Oracle Database Cloud Service Oracle Providers for ASP.NET Installation Upgrading Oracle Providers for ASP.NET File Locations After Installation Oracle Providers for ASP.NET Object References1.4 Connecting to Oracle Database Cloud ServiceOracle Providers for ASP.NET support connectivity with Oracle Database Cloud Serv‐ices, including Oracle Autonomous Database.Set-up InstructionsOracle recommends using the latest Oracle Providers for ASP.NET version availablewhen connecting to Oracle Database Cloud Services. You will find instructions abouthow to download, install, and configure Oracle Providers for ASP.NET below.Oracle Autonomous Datab
Changes in Oracle Providers for ASP.NET in ODAC 12c Release 4 xiv Changes in Oracle Providers for ASP.NET Release 11.2.0.2 xiv Changes in Oracle Providers for ASP.NET Release 11.2.0.1.2 xv 1 Introduction to Oracle Providers for ASP.NET 1.4 Connecting to Oracle Database Cloud Service 1-1 1.1 Overview of Oracle Providers for ASP.NET 1-1 1.2 Oracle Providers for ASP.NET Assembly 1-4 1.3 System .
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
xii Oracle Workflow Developer's Guide Audience for This Guide Welcome to the Oracle Workflow Developer's Guide. This guide assumes you have a working knowledge of the following: The principles and customary practices of your business area. Oracle Workflow Oracle Workflow Developer's Guide. Workflow.
Changes in Oracle SQL Developer Release 18.1 xlviii 1 SQL Developer Concepts and Usage 1.1 About SQL Developer 1-2 1.2 Installing and Getting Started with SQL Developer 1-2 1.3 SQL Developer User Interface 1-3 1.3.1 Menus for SQL Developer
7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
Specific tasks you can accomplish using Oracle Sales Compensation Oracle Oracle Sales Compensation setup Oracle Oracle Sales Compensation functions and features Oracle Oracle Sales Compensation windows Oracle Oracle Sales Compensation reports and processes This preface explains how this user's guide is organized and introduces
The API commands in this guide are applicable to the Polycom RealPresence Group 300, Polycom RealPresence Group 500, and Polycom RealPresence Group 700 systems.
