OracleCommandBuilder problem

[Anirudh Srivastava]

Hi,

I am using .NET Provider for Oracle, .NET Framework 1.1
to connect to Oracle 9i database instance. I am using the
OracleCommandBuilder.DeriveParameters to get the
parameters for a given stored procedure.
For some stored procedures, I get the OracleParameter[]
with the same parameter getting repeated. In other words,
I get double the number of parameters in the collection
than the actual number of parameters. When I recreate the
stored procedure with the different name then it works
fine.

Please advice.

Thanks

 

[Dmitry Arefiev]

Hello !

Analyzing query, which provider sends to Oracle server
to get stored procedure parameters, i see at least one bug.
It does not distinguish overloaded procedures. So, will be
returned all parameters for all overloaded procedures with
the same name. May be it is your case ?

Regards,
Dmitry

--
Dmitry L. Arefiev, director of gs-soft.ru ltd.
Solutions for successful companies

ICQ: 50741007
EMail: (e-mail address removed)
Company: http://www.gs-soft.ru