title: Not allowed to return a result set from a trigger
body: <p>I have problem: </p>
  
  <p>I created procedure : </p>
  
  <pre><code>CREATE PROCEDURE `tran_sp` ()
  BEGIN
    SELECT 'procedure runned!';
  END
  $ 
  </code></pre>
  
  <p>It's works !</p>
  
  <pre><code>mysql&gt; CALL tran_sp()$
  +-------------------+
  | procedure runned! |
  +-------------------+
  | procedure runned! |
  +-------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>Then i created trigger : </p>
  
  <pre><code>mysql&gt; CREATE TRIGGER my_trigger1
      -&gt;     AFTER INSERT ON users
      -&gt;     FOR EACH ROW
      -&gt; BEGIN
      -&gt;          CALL tran_sp();
      -&gt; END$
  
  
  mysql&gt; INSERT INTO users VALUES(166,156)$
  </code></pre>
  
  <p><strong>ERROR 1415 (0A000): Not allowed to return a result set from a trigger
  mysql></strong></p>
  
  <p>Help me please.</p>