title: HSQLDB and Stored procedures
body: <p>There is probably a good document out there that explains how to create a stored proc in HSQLDB. Here's where I'm getting stuck :-</p>
  
  <pre><code>CREATE PROCEDURE addone(ivar int)
  BEGIN ATOMIC
  DECLARE result CURSOR FOR SELECT ivar+1;
  OPEN result;    
  END
  </code></pre>
  
  <p>However is simply get ERROR back - no details - any ideas anyone ?</p>