Hi All,
I want to use stored procedure returning cursor in my C# application.
Database used is oracle 9i.
I tried the this way , still error persists.
My stored Procedure is in package "PKG_GET_PROCESSING_AREA"
I am using "System.Data.OleDb" as a provider

PROCEDURE SP_GET_PROCESSING_AREA (P_GUID IN VARCHAR2, P_REVISION IN
VARCHAR2, P_VERSION IN VARCHAR2, P_RC OUT PKG_UTIL.refC) IS

BEGIN

OPEN P_RC FOR select * FROM PROCESSING_AREA_T

where TRIM(GUID) = TRIM(P_GUID) AND

TRIM(REVISION) = TRIM(P_REVISION) AND

TRIM(VERSION) = TRIM(P_VERSION)

ORDER BY GUID;

END SP_GET_PROCESSING_AREA;

Dotnet code is

OleDbCommand CMD_SP_GET_PROCESSING_AREA = new
OleDbCommand("PKG_GET_PROCESSING_AREA.SP_GET_PROCE SSING_AREA",
this.ConnectionFIM);

CMD_SP_GET_PROCESSING_AREA.CommandType =CommandType.StoredProcedure;

CMD_SP_GET_PROCESSING_AREA .Parameters.Add("@P_GUID",
OleDbType.VarChar).Value = tempPA.LatestSavedVersion.ID;

CMD_SP_GET_PROCESSING_AREA.Parameters[0].Direction =
ParameterDirection.Input;

CMD_SP_GET_PROCESSING_AREA .Parameters.Add("@P_REVISION",
OleDbType.VarChar).Value = tempPA.LatestSavedVersion.Revision;

CMD_SP_GET_PROCESSING_AREA.Parameters[1].Direction =
ParameterDirection.Input;

CMD_SP_GET_PROCESSING_AREA .Parameters.Add("@P_VERSION",
OleDbType.VarChar).Value = tempPA.LatestSavedVersion.Version;

CMD_SP_GET_PROCESSING_AREA.Parameters[2].Direction =
ParameterDirection.Input;

ConnectionFIM.Open();

System.Data.OleDb.OleDbDataReader GetRow =
CMD_SP_GET_PROCESSING_AREA.ExecuteReader();

----------------------------------------------------------------------------
-----------------------------------

When the above code is executed I am getting exception in stored procedure
invalid number/type of arguments passed.

Can anyone please help me out figuring what might be going wrong?

Thanks &Regards

Shailaja