Cannot derive parameters for overloaded stored procedure or function

kenny_guo

Cannot derive parameters for overloaded stored procedure or function,
不知道側問題該如何處理???
希望大家幫忙.

纵横四海

在下面找到了一点资料，并拷贝下来了
http://www.dotnet247.com/247reference/msgs/34/170829.aspx



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?

thanks,

Marc
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
racle 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
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
David,

I understand what overloading is.

The problem is, the stored procedure is not overloaded at all!

Regards,

Marc
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
Ok, well then perhaps you could post code reproducing the problem.

David
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
David,

the problem seems to be related to the database version.

DeriveParameters works on 8.1.7, it does not work on 8.0.5. Is there a
minimum version
I need?

Thanks,

Marc

laozhu

学习~~

sunjinhai

學習中﹗
英語太爛了我