How do I create a stored procedure in heidisql?
<p>I'm trying to create a stored procedure in heidisql (mysql).</p>
<pre><code>CREATE PROCEDURE SP_FORM20_POST(
    P_SESSIONID     VARCHAR(256)
)
BEGIN
    INSERT INTO tbForm20
        ( SESSIONID, RegDT)
    VALUES
        ( P_SESSIONID, NOW()); 
END
</code></pre>
<p>This is my query. I'm trying to create this procedure, but occur some error:</p>
<blockquote>
<p>Error code is 1064</p>
<p>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near'' at line 8&quot;.</p>
</blockquote>
<p>However, I don't know wrong syntax. What is wrong?</p>
<p>I want to success in heidisql tool. I don't want other db tool.
Please help me.</p>