Oracle Stored Procedure

CREATE OR REPLACE PACKAGE PKG_VERIFY AS




PROCEDURE prc_Verify  (i_id  IN  tablename.id%TYPE,
o_cursor         OUT    sys_refcursor,
o_ErrorCode      OUT       VARCHAR2);


END PKG_VERIFY;

create or replace
PACKAGE BODY PKG_VERIFY IS

PROCEDURE prc_Verify
                                 (i_id          IN  tablename.id%TYPE,
                                  o_cursor         OUT    sys_refcursor,
                                  o_ErrorCode      OUT       VARCHAR2)
  IS
  BEGIN

   o_Errorcode := SQL_OK;
  OPEN o_cursor FOR
      SELECT Acc,Bcc
      FROM   tablename
      WHERE  id = i_id;

   EXCEPTION
                 WHEN NO_DATA_FOUND THEN
                    o_Errorcode := 'No Record Found';
  END;
END PKG_VERIFY;

SqlConnection lSQLConn = null;
SqlCommand lSQLCmd = new SqlCommand();
//Declare a DataAdapter and a DataSet
SqlDataAdapter lDA = new SqlDataAdapter();
DataSet lDS = new DataSet();
 
//...Execution section
 
// create and open a connection object
lSQLConn = new SqlConnection(connStr);
lSQLConn.Open();
//The CommandType must be StoredProcedure if we are using an ExecuteScalar
lSQLCmd.CommandType = CommandType.StoredProcedure;
lSQLCmd.CommandText = "sp_YourSPName"; 
lSQLCmd.Parameters.Add(new SqlParameter("@Parm1", aParm1));
lSQLCmd.Parameters.Add(new SqlParameter("@Parm2", aParm2));
lSQLCmd.Parameters.Add(new SqlParameter("@Parm3", aParm3));
lSQLCmd.Parameters.Add(new SqlParameter("@Parm4", aParm4));
 
lSQLCmd.Connection = lSQLConn;
//Fill the DataAdapter with a SelectCommand
lDA.SelectCommand = lSQLCmd;
lDA.Fill(lDS);