Well, at the time when I was testing ODP.NET 9i (late last year/earlier this year), the DataMapper required DeriveParameters support for stored procedures.   Then there's always the bug fixes and other new features.  :-)

http://www.oracle.com/technology/docs/tech/windows/odpnet/readme10104.txt

Bugs Fixed in 10.1.0.4.0 version
================================
4066828: Unmanaged exceptions return -3000 error without further information
4028378: Need attributes/methods on OracleParameter/OracleCommand classes
4020081: ODP.NET -3000 errors under high load
3937454: Calling cancel before command execution causes an error
3930596: Output bind variable initialized with blanks using ParameterDirection.OUTPUT
3897454: Aborting selecting thread fails with internal error -3000
Bugs Fixed in 10.1.0.3.01 version
=================================
3912525: INSERT ARRAY OF DBNULL.VALUE CAUSES AN EXCEPTION
3908190: CONNECTION REQUEST RETURNS ORA-1034 AFTER RESTARTING THE DATABASE
3906299: ARRAYBIND WITH DBNULL.VALUE & ORACLETIMESTAMP CAUSES INTERNAL ERROR
3863034: DERIVEPARAMETERS RETURNS INVALIDOPERATIONEXCEPTION FOR SYS.XMLTYPE
3838832: DERIVEPARAMETERS THROWS ORACLEEXCEPTION AGAINST 8.1.7.4.1 DB
3833810: INTERNAL ERROR WHEN REQUESTING GLOBALIZATION OBJ AFTER CON IS FREED
3829607: OS AUTH DISABLED IF USERID OF "/" BEGINS/ENDS WITH SPACES IN QUOTES
3816643: MEM LEAK WHEN USING SAME CON TO OPEN MANY TIMES WITH POOLING OFF
3773442: EXECUTION FAILS AFTER DERIVEPARAMETERS FOR LONG AND LONG RAW PARAMS
3757186: ORACLECOMMANDBUILDER.DERIVEPARAMETERS PERFORMANCE DEGRADATION
3698431: INTERNAL ERROR WHEN USING ODP.NET WITH REF CURSORS AND SYS.XMLTYPE
3450763: CREATING ORACLEXMLTYPE OBJECT FAILS AFTER A SCHEMA BASED OPERATION
3365691: ARGUMENTNULLEXCEPTION WHEN USING A SELECT STATMENT WITH WITH CLAUSE
2925742: CALLING ORACLEDATAADAPTER.UPDATE FOR A SYNONYM FAILS

Hope this helps!

Roberto


On 12/5/05, Jeremy Gray <[EMAIL PROTECTED]> wrote:












Roberto,

 

Can you provide any specific insight into your recommendation against the 9i client?

 

Thanks in advance,

 

Jeremy Gray

 


From: Roberto R [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 02, 2005 10:35 AM
To: [email protected]
Subject: Re: Oracle provider with iBatis dataMapper 1.2

 

Tests were run for System.Data.OracleClient, ODP.NET 9i, and ODP.NET 10g.  (I would not recommend using ODP.NET 9i with the DataMapper.)

>From my experience, System.Data.OracleClient was the "easiest" to use right away, but ODP.NET 10g offers some advanced features that could be used outside of the DataMapper. 

Roberto

 


Reply via email to