title: Error with mysql procedures ERROR 1304 & ERROR 1305
body: <p>I am new to using procedures and cannot seem to get mine working. I am using MySQL v5.1.36 and inputing my code using MySQL Console on a WAMPP server. If I go to (re)create the procedure. I get error #1304 (42000).</p>
  
  <pre><code>mysql&gt;  DELIMITER //
  mysql&gt;
  mysql&gt;  CREATE PROCEDURE modx.getCRID (IN x VARCHAR(255),OUT y INT)
      -&gt;  BEGIN
      -&gt;          DECLARE y INT;
      -&gt;          SELECT id INTO y
      -&gt;          FROM `modx`.coverage_region
      -&gt;          WHERE `coverage_region`.name = x;
      -&gt;  END//
  ERROR 1304 (42000): PROCEDURE getCRID already exists
  mysql&gt;
  mysql&gt;  DELIMITER ;
  </code></pre>
  
  <p>However, if I try to use the procedure I get error #1305 (42000).</p>
  
  <pre><code>mysql&gt; USE modx;
  Database changed
  mysql&gt; SET @crID = modx.getCRID("South East");
  ERROR 1305 (42000): FUNCTION modx.getCRID does not exist
  </code></pre>
  
  <p>If the procedure exists for one how can it not exist for the other? What am I doing wrong.</p>