Re: test script

Hello,

Here is my specific example. I need to reuse that newid in another procedure.

sql> \i test_script.sql
Nov 30, 2019 4:36:22 PM org.hsqldb.cmdline.SqlFile processSpecial
SEVERE: SQL Error at 'file:test_script.sql' line 2:
"call Library.Book_Insert(newid,'My New Book')"
dynamic parameter or variable required as INOUT or OUT argument

-----
DROP SCHEMA IF EXISTS Library CASCADE;
/

CREATE SCHEMA Library;
/

CREATE TABLE Library.Book
(
Id IDENTITY,
Name VARCHAR(8000),
CONSTRAINT Book_primaryKey PRIMARY KEY (Id)
);
/

CREATE PROCEDURE Library.Book_Insert (
OUT newid INTEGER,
IN v_Name VARCHAR(8000)
)
MODIFIES SQL DATA BEGIN ATOMIC
INSERT INTO Library.Book (
Id,
Name
) VALUES (
DEFAULT,
v_Name
);
SET newid = IDENTITY();
END;
/
-----