Re: test script

Jorge Garcia de Alba <[email protected]> Sat, 30 Nov 2019 20:14:47 -0600

Newsgroups	gmane.comp.java.hsqldb.user
Message-ID	<CAEVgvV9DsqNtqvG_3p=YwJ5ja=x6g5mQ27ytKf8w8zKH301oiw@mail.gmail.com>

Hello,

Code below works.

cat test2.sql

DROP PROCEDURE IF EXISTS Library.Test;
CREATE PROCEDURE Library.Test ()
MODIFIES SQL DATA BEGIN ATOMIC
DECLARE
outvar INTEGER;
--
SET outvar = 0;
--
CALL Library.Book_Insert(outvar,'My New Book');
--
END
.;
COMMIT;
CALL Library.Test();
SELECT * FROM Library.Book;