title: OperationalError: (1414, 'OUT or INOUT argument 1 for routine 'stored procedure name' is not a variable or NEW pseudo-variable in BEFORE trigger')
body: <p>I am having issues in calling stored procedure with out parameter in python using Airflow mysqlhook</p>
  
  <p>signature of the stored procedure is 
  CREATE PROCEDURE <code>sp_stage_processdata</code>(out p_status INT)</p>
  
  <p>src_cursor.execute("CALL sp_stage_processdata(%s);", (status,))</p>
  
  <p>i am getting error </p>
  
  <p>OperationalError: (1414, 'OUT or INOUT argument 1 for routine sp_stage_processdata is not a variable or NEW pseudo-variable in BEFORE trigger')</p>
  
  <p>During handling of the above exception, another exception occurred:</p>
  
  <p>I tried removing out parameter and procedure executes well with python so there is nothing wrong.</p>
  
  <p>I am not able to use cursor.callproc because of version issue.</p>