title: Creating HSQLDB Procedure in DbVisualizer
body: <p>I am trying to create the following simple <code>HSQLDB</code> procedure, by a DbVisualizer client.</p>
  
  <pre><code>DROP PROCEDURE IF EXISTS my_procedure;
  CREATE PROCEDURE my_procedure(OUT my_output INTEGER, IN my_input INTEGER)
          MODIFIES SQL DATA -- NO SQL
          BEGIN ATOMIC
                  SET my_output = my_input;
          END
  </code></pre>
  
  <p>Error message:</p>
  
  <pre><code>[CREATE - 0 rows, 0.001 secs]  [Code: -5590, SQL State: 42590]  unexpected end of statement:  required: ; : line: 3
  [END - 0 rows, 0.000 secs]  [Code: -5581, SQL State: 42581]  unexpected token: END
  ... 2 statement(s) executed, 0 rows affected, exec/fetch time: 0.001/0.000 sec  [0 successful, 2 errors]
  </code></pre>
  
  <p>It looks like <a href="https://sourceforge.net/p/hsqldb/discussion/73674/thread/58937080/" rel="nofollow noreferrer">there is a problem</a> with the interpretation of <code>;</code>, but I could not find anything in <code>HSQLDB</code> equivalent to <code>MySQl</code> <code>delimiter</code>. </p>
  
  <p><strong>How do I get around this problem?</strong></p>