Re: OracleCommandBuilder: DeriveParameters

"Marc Croymans" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I get following message when I try to use DeriveParameters on an
> OracleCommandBuilder:
>
> 'Cannot derive parameters for overloaded stored procedure or function.'
>
> Anyone seen this? Any input on how to resolve this?
>

Oracle supports overloading of PL/SQL stored functions and stored
procedures, much like C# and VB.NET support method overloading.

Trying to derive parameters for an overloades stored procedrure is like
asking reflection what the parameters to Integer.Parse, or String.Format
are. They are overloaded, so they don't have just one set of parameters.



create or replace procedure foo(n number)
is
begin
null;
end;

and

create or replace procedure foo(v varchar2)
is
begin
null;
end;


For such a procedure, you obviously cannot derive the parameters.

David