CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllCreditsByCurrentDebitor`()
SELECT * FROM Credits where DebitorID=debitorID order by OpenDate

internal ArrayList GetAllCreditsForDebitor(string debitorID)
        {
            ArrayList allCredits = new ArrayList();
            using (MySqlConnection con = new MySqlConnection(connectionString))
            {
                //string query=String.Format("SELECT * FROM Credits where DebitorID='{0}' order by OpenDate",debitorID);
                MySqlCommand com = new MySqlCommand("GetAllCreditsByCurrentDebitor", con);
                com.CommandType = System.Data.CommandType.StoredProcedure;

                MySqlParameter param = new MySqlParameter();
                param.ParameterName = "@debitorID";
                param.Value = debitorID;
                param.MySqlDbType = MySqlDbType.VarChar;
                param.Direction = System.Data.ParameterDirection.ReturnValue;
                com.Parameters.Add(param);
                try
                {
                    con.Open();
                    MySqlDataReader dr = com.ExecuteReader();//System.Data.CommandBehavior.CloseConnection
                    if (dr.HasRows)
                    {
                        foreach (DbDataRecord result in dr)
                        {
                            allCredits.Add(result);
                        }
                    }
                    //con.Dispose();
                }
                catch(MySqlException)
                {

                }
            }
            return allCredits;
        }

param.Direction = System.Data.ParameterDirection.Input;

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllCreditsByCurrentDebitor`(IN `debitorID` VARCHAR(36)) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER SELECT * FROM Credits where DebitorID=debitorID order by OpenDate