By way of Sam:
MSDN has published a new article by Bill Hamiliton Advanced Data Access with ADO.NET and Oracle on using ADO.NET 1.1 to retrieve data from complex Oracle data types.
While the article is good in showing you various advanced techniques, I have a general question. Does anyone else notice most of the examples, in the way the SQL command text is written, are vulnerable to SQL Injection (yes, it can be done with Oracle too!)?
Learn the techniques, but still practice secure, safe coding!