Click here to Skip to main content
15,922,533 members
Articles / Programming Languages / SQL

How to use Oracle 11g ODP.NET UDT in an Oracle Stored Procedure's Where clause

Rate me:
Please Sign up or sign in to vote.
4.14/5 (5 votes)
3 Mar 2009CPOL 74.9K   4   20  
Passing a VARRAY custom type from .NET and using it in a Where clause in an Oracle Stored Procedure.


Daily Counts


Weekly Counts


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Architect BAE Systems IT
United States United States
BAE Systems IT (Client – US BLS) (Washington, DC), SEP 2004 – Present
Senior Software Architect
Duties and Accomplishments – Designed, Documented, Implemented, & Tested:
1. Currently in Progress: IPS Collection System (Java 6, Oracle 11g, WebLogic 11g, SOA, JNDI, JMS, EJB, SQL Developer, Star UML, Adobe Flex/AIR, DI/IOC Parsley Framework Container, Live Cycle Data Services DMS, SQLite & RIA Online/Offline Synchronization with Distributed Transactions).

2. Currently in Progress: Additional 10 hours/week from home for a different department (Sean Curran’s) in order to implement Jasper Reports with Spring RESTFUL services according to user’s requirements by utilizing Spring toolkit IDE, IReport Designer for Jasper Reports, Weblogic and Oracle PL/SQL.

3. In Production: JANUS Forms & Batch Processing System (.NET 3.5, WCF, Win Forms, WPF, Oracle 11g, ODP.NET, SOA, SQL Developer, Visio, Visual Studio Team Architect 2010).

4. On Going: Conducting .NET/Java resource interviews for BAE Systems

5. On Going: Successfully helping other .NET/Java developers in order to troubleshoot the issues they are facing.

6. On Going: Support for Fairfax Imaging Fax/Scanner Software solutions with Brooktrout Fax.

Comments and Discussions