AD.Net and Oracle Provider

[Guest]

Using ADO.Net to connect to Oracle 8i using OracleClient managed provider.

Learnt that OracleClient data provider does not support ODBC escape syntax
for calling SPs or Functions. For example CommandText = "{?=Call
Function_NAME(?,?...)}". OracleClient does not populate the Parameter
Collection based on ? place holders. This was the default behavior with OleDB
provider in ADO world when Active connection is set.

There is no Prameter.Refresh method. Plus CommandBuilder objects
DeriveParameter works only when CommandType is StoredPorc. Is there any way I
could have the Parameter collection populated by .Net provider (Automatically
or by calling a method)?
Can ODP.Net provide me help in this regard?

I do not want to use System.Data.OleDB cos it is not 100% managed provider
since it relies on OleDB provider beneath which is a performance bottleneck!
Any help in this matter will be appreciated.

Thanks and Regards
Nilesh

 

[Cowboy \(Gregory A. Beamer\)]

Try ODP.NET from Oracle (otn.oracle.com) as it is a better option for Oracle
development.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside the box!
*************************************************

 

[Paul Clement]

¤ Using ADO.Net to connect to Oracle 8i using OracleClient managed provider.
¤
¤ Learnt that OracleClient data provider does not support ODBC escape syntax
¤ for calling SPs or Functions. For example CommandText = "{?=Call
¤ Function_NAME(?,?...)}". OracleClient does not populate the Parameter
¤ Collection based on ? place holders. This was the default behavior with OleDB
¤ provider in ADO world when Active connection is set.
¤
¤ There is no Prameter.Refresh method. Plus CommandBuilder objects
¤ DeriveParameter works only when CommandType is StoredPorc. Is there any way I
¤ could have the Parameter collection populated by .Net provider (Automatically
¤ or by calling a method)?
¤ Can ODP.Net provide me help in this regard?
¤

The ODP.NET provider does not support the Oracle 8i client.

DeriveParameters is not recommend as it requires another round trip to the server.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)