Error while calling MysqlHelper.ExecuteNonQuery on a store procedure with a OUT parameter.
Posted by: Kaustubh Desai
Date: October 18, 2018 11:44AM

Error when using MysqlHelper.ExecuteNonquery on a stored procedure with OUT parameter
----------
string string procSaveNotificationClickTime = "call test.save_user_alert_last_read_time(@p_user_id,@p_last_read_time,@r_return)";
string connectionString = ConfigurationManager.ConnectionStrings["testdb"].ConnectionString;
MySqlParameter[] parameters = new MySqlParameter[3];
parameters[0] = new MySqlParameter("@p_user_id", al.uid);
parameters[1] = new MySqlParameter("@p_last_read_time", lastReadTime);
parameters[2] = new MySqlParameter("@r_return", MySqlDbType.Int32);
parameters[2].Direction = ParameterDirection.Output;

retCode = MySqlHelper.ExecuteNonQuery(connectionString, procSaveNotificationClickTime, parameters);

----------

Get following error:"OUT or INOUT argument 3 for routine test.save_user_alert_last_read_time is not a variable or NEW pseudo-variable in BEFORE trigger"

Options: ReplyQuote


Subject
Written By
Posted
Error while calling MysqlHelper.ExecuteNonQuery on a store procedure with a OUT parameter.
October 18, 2018 11:44AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.