Loading Procedures Using SqlFile

Jorge Garcia de Alba <[email protected]> Wed, 6 May 2020 17:51:11 -0500
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <CAEVgvV-fbSbs_5yfOz1qN-KabW1JJzKRSzW8+=ydd28Pfmw_gA@mail.gmail.com>
Hello,

I am trying to load my procedures using SqlFile but it throws error.
Do you have any suggestions? Thanks.

script.sql ->

CREATE PROCEDURE Snippet.Category_Insert (
IN v_Id INTEGER,
IN v_Name LONGVARCHAR
)
MODIFIES SQL DATA BEGIN ATOMIC
INSERT INTO Snippet.Category (
Id,
Name
) VALUES (
v_Id,
v_Name
);
END;