Cannot Execute Query Package in C# using ODP.Net

See more:

C#

Oracle

ODP.NET

WCFServices

Dear All master,


corresponding tag title line above me ,
explanation of cases like this :

I build applications using WCF, and WCF there is a function to query execution, his code below:

public string UploadBoxs(DataSet dataSet)
{
    var conn = new OracleConnection(_connstring);
    var slofbar = dataSet.Tables[0].Rows.Cast<DataRow>().Aggregate("", (current, dr) => "'" + dr["slof_barcode"] + "'," + current);
    slofbar = slofbar + "''";

    var cmd = new OracleCommand("delete_byslof.delete_byslof", conn) { CommandType = CommandType.StoredProcedure};

   cmd.Parameters.Add("in_barcodes", OracleDbType.Varchar2, slofbar, ParameterDirection.Input);
   conn.Open();
   cmd.ExecuteNonQuery();
   conn.Close();

// and more code below here............

and this my package oracle :

CREATE OR REPLACE PACKAGE delete_byslof
AS
   PROCEDURE delete_byslof (in_barcodes IN VARCHAR2);
END delete_byslof;
/
CREATE OR REPLACE PACKAGE BODY delete_byslof
AS
   PROCEDURE delete_byslof (in_barcodes IN VARCHAR2)
   IS
         PRAGMA AUTONOMOUS_TRANSACTION;
   BEGIN
      DELETE from t_productions
       WHERE slof_barcode IN (in_barcodes);
      COMMIT;
  EXCEPTION
      WHEN OTHERS
      THEN
         ROLLBACK;
   END;
END delete_byslof;
/

when running my applications,the above code does not want to delete the data in oracle, but no error message is also ..
I try to put a breakpoint for debugging, but no errors in the code that processes all ...
I use Oracle 11g Express editions and ODP.NET lastest version from oracle today...

please, somebody can help me...
thank you very much...
advance greetings to all