title: MySQL: how to call a stored procedure with only an output parameter?
body: <p>From my instruction book, I created the following procedure in which the INSERT statement will yield an error:</p>
  
  <pre><code>create procedure f1
  (out error char(5))
  begin
  declare continue handler for SQLSTATE '23000'
  set error='23000';
  set error ='00000';
  insert into teams values(2,27,'derde');
  end;
  </code></pre>
  
  <p>However, it doesn't say how to call this procedure. I tried</p>
  
  <pre><code>call f1;
  
  call f1();
  
  call f1(error);
  </code></pre>
  
  <p>but none of these works.</p>
  
  <p>Thanks!</p>