.NET Provider for Oracle and Data Access Application Blocks (OracleHelper.cs) problem

[Phil Adams]

I am using the OracleHelper.cs to access
System.Data.OracleClient.dll. I am calling
OracleHelper.ExecuteDataset
(connectString,storedProc,OracleParameterArray) to return
a result set. I populate the array with a VARCHAR2 and a
cursor to capture the output).

Debugging, I see that OracleHelper successfully makes a
connection to the database but then calls
System.Data.OracleClient.CommandBuilder.DeriveParameters
to retrieve the parameters for the stored procedure. This
call results in an unhandled exception in
System.Data.OracleClient.dll.

Can anyone help or respond to this? How can I get this
message to Microsoft Technical Support?

Thanks

-----------------------------
This message is posted by http://asp.forumszone.com

[Microsoft Developer Support]

What exactly is Oraclehelper.cs? Is this a class file? If so who wrote it?
We will need more information. If at all possible can you put a try catch
block around the deriveparameters statment? It may be that you are not
setting the commandtype. The commandtype must be set to stored proc for
deriveparameters to work.

Thanks,
Terrell A.
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

[Joshua Flanagan]

Oraclehelper.cs is an implementation of the Microsoft Data Access Block
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/
daab-rm.asp

that is included with the Nile 3.0 sample application
http://msdn.microsoft.com/code/default.asp?url=/code/sample.asp?url=/MSDN-FI
LES/026/002/846/msdncompositedoc.xml

They've done all the dirty work for you, so you only need to include the
Oraclehelper.cs file in your project (or compile it as an assembly to
include).

"Microsoft Developer Support" <terr...@onlinemicrosoft.com> wrote in
message news:yN7jU9LOCHA.1828@cpmsftngxa08...

[Microsoft Developer Support]

I looked at the class but I did not see any deriveparameter statement. It
sounds like you may not be passing it what it is looking for. Did you
modify the class in any way? Try writing your own code to call the stored
proc with the Oracleclient, does that work?