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)
Database db = DatabaseFactory.CreateDatabase();

new object[]
{ sUserId,
dLockCd });
Dec 10, 2007 at 6:16 PM

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.