title: HSQL why I get error when use GET DIAGNOTICS <variable> = ROW_COUNT
body: <p>I want to get the value of rowcount (like other dbms provides the <code>@@rowcount</code>) from hsqldb in the store procedure, but I get confused about the exception that informs me that </p>
  
  <blockquote>
    <p>Unexpected Token: GET, required:END</p>
  </blockquote>
  
  <p>Can anyone help me solve this problem?</p>