oraclecommandbuilder.deriveparameters

[Erwan L.]

hello,
i'm having a hard time with deriveparameters.

when i use the oracleclient provider, oraclecommandbuilder.deriveparameters
throws a system.invalidoperationexception:
"Cannot derive parameters for overloaded stored procedure or function.".
my stored procedure is a regular (not overloaded) one with 2 parameters.
PROCEDURE INSERTNUA(CODE VARCHAR2,LIB1 VARCHAR2,LIB2 VARCHAR2);

i then tried the same code with oledbcommandbuilder.
this time it works but only if my stored procedure is standalone (not in a
package).
if the stored procedure is within a package,
it does not throw any exception but does not fill either my parameters
collection (count property=0).

any help appreciated,
thx !

Erwan L.
erwan at free.Fr

 

[Miha Markic]

Hi Erwan,

Why don't you create the adapter(with parameters) rather at design time?