Oracle Package containing an overloaded function

Topics: Data Access Application Block
Dec 10, 2007 at 3:45 PM
I'm using Enterprise Library 3.1 with Microsoft Oracle data provider. I am using ExecuteNonQuery to invoke an Oracle Package containing an overloaded procedure. I am receiving the following :

" Cannot derive parameters for overloaded stored procedure or function"

Can someone point me in the direction of how to access this overloaded procedure.... Thanks.

The Procedure contains the following 2 signatures
PROCEDURE UserLock(vUser IN varchar2,nLockReason IN number)
PROCEDURE UserLock(vUser IN varchar2, nLockReason IN number,nStrikeCount IN number)

My Data Access is

public void LockUser(string sUserId, Double dLockCd)
{
try
{
Database db = DatabaseFactory.CreateDatabase();

db.ExecuteNonQuery("Security_Pkg.UserLock",
new object[]
{ sUserId,
dLockCd });
}
catch
{
throw;
}
}
Dec 10, 2007 at 6:16 PM
Hi,

You won't be able to use automatic parameter discovery with your overloaded procedure, so you will need to manage them yourself. Look at this help topic ms-help://ms.EntLib.2007May/EnterpriseLibrary/html/04-170-Executing_a_Command_and_Accessing_Output_Parameters.htm for some sample code.

Regards,
Fernando