Executing a PL/SQL Function

Create or replace function func_RetrieveCount
RETURN NUMBER
IS
IntRecordCount NUMBER;
BEGIN
Select count (*) INTO intRecordCount FROM Products;
RETURN intRecordCount;
END;

/

 

Private void btnRetrieveCount_Click (object sender, EventArgs e)
{
String _ connstring = "Data Source = localhost/NEWDB; User
Id = EDZEHOO; Password = PASS123 ;";
Try
{
OracleConnection _ connObj = new OracleConnection (_ connstring );
_ ConnObj. Open ();
OracleCommand _ cmdObj = _ connObj. CreateCommand ();

_ CmdObj. CommandText = "func_RetrieveCount ";
_ CmdObj. CommandType = CommandType. StoredProcedure;
 
// Declare the return parameter
OracleParameter _ retValueParam = new OracleParameter ();
_ RetValueParam. ParameterName = "Any_name ";
_ RetValueParam. OracleDbType = OracleDbType. Int32;
_ Retvalueparam. Direction = parameterdirection. returnvalue;
_ Cmdobj. Parameters. Add (_ retvalueparam );
 
_ Cmdobj. executenonquery ();
MessageBox. Show ("the return value is:" + _ retvalueparam. value. tostring ());
_ Connobj. Close ();
_ Connobj. Dispose ();
_ ConnObj = null;
}
Catch (Exception ex)
{
MessageBox. Show (ex. ToString ());
}
}